Search results

I had previously set up a self certificate for signing macros however my machine has been upgraded to 2003 and it now states that the certificate is untrusted. What do I need to do to enable this certificate again or do I need to create a new one and if so how. Regards, Matt

Thank You Regards, Matt

I have no problems in excel create a CheckBox and being able to use it but in word I can create it but unable to actual tick and un-tick. I have looked at the code in properties and it states active but when I return to the word doc and try to put a tick into it it always seems to remain in edit...

Yes, Thank you. I think that I can adapt to suit my application. Regards, Matt

OK Holger Thanks. Regards, Matt

I have a range of cells with a dropdown list if the user does not pick from the list and types an entry the following expected error notice is given:- "The value you entered is not valid" "A user has restricted values that can be entered into this cell" On this error, instead of receiving it...

Holger as expected they both work well and in use but I have an inquisitive mind and a knack for not looking too far ahead in what I would like to do. Where the code says "Is Nothing....." is there a list of conditions that could be placed after the "Is" to give another condition such "Is...

Thank You Holger I will give them both a go. Regards, Matt

Can you please tell me the code that will:- If any cell in Range H is changed that a message box appears that says "Please create Hyperlink to answer". The user just needs to click OK to continue. Its not a condition that they create a hyperlink to continue. Regards, Matt

Holger I would like to try and avoid a UserForm and VBA, but if I enter text in the cell with a dropdown list is sys that it is an invalid entry so, is there a way without VBA to enter text into the cell that will copy the entry at the bottom of the range where the list originated from? Hope...

Thanks Guys Regards, Matt

Thanks for that. Can you tell me what the "me" syntax means and how it is used. Regards, Matt

On UserForm1 I have 15 TextBox's (TextBox1 to TextBox15) I have an OptionButton1 What I would like to happen When OtionButton1 is checked, then TextBox's 1 to 15.Enabled = False I just can't work out how to loop through this event. I suppose what I am really after is learning the process for...

I have named a range say "range1" and refers to: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1) which of course allows the range to vary. On sheet2 in the range Column C there is a drop down list in each cell that refers to: =range1 What I would like: Should the user not find from the list...

Thanks Shades Another good Ad-In Regards, Matt

Thanks Holger That was embarrassingly simple. Regards, Matt

I have a ComandButton1 at the top left hand side of my worksheet. When I scroll down the sheet the CommandButton1 dissapears (as expected). Is there a way to ancor it to a position so it remains visible when scrolling? Thanks, Matt

Is it possible to improve this index function so that the sheet that is the index remains visible at all times whilst scrolling through the sheets? I would assume that this would need to be done through code? Thanks, Matt

Thank You Shades That was a great link and I have installed it, as suggested there are a number of benificial macro's loaded which will save quite a fair few key strokes. Matt

Is there a way, and if there is would you please let me know of:- If I highlight a number of worksheets in a workbook that the total number highlighted could be indicated in some way as it is proving very hard to manually count as when you scroll across keeping track of where you are is...