Custom button enabling/disabling

Hello,

I have made a questionnaire style program, which has several custom buttons. When I mean custom, I mean buttons I created from text boxes, which are assigned to a certain macro in my code (in a Module).

I would like to learn how to disable and enable these buttons in my code.

I have tried giving my buttons names, e.g. for the start button I have named it startBurron. I know it is using the enabled property but when I try something like:

Please Login or Register  to view this content.

I get a variable not defined error. Can someone please explain?

The short answer is to purely add "Me." in front of the line

Please Login or Register  to view this content.

Remember that this line should be in the correct module to work.

Hi,

I get a Invalid use of Me keyword error when I put "Me" in front of that statement. All my code is in Module 1 (which is the only module I have). Can I only use "Me" in the code of my 'test' worksheet?

Sorry, my mistake.
The problem is that it doesn't know whete to find the startbutton.
If you use me, it searches for the startbutton in the sheet or userform connected to the module.
Otherwise you will have to indicate where exactly that button is situated. If it is in sheets1 then:
sheet1.startbutton.enabled = false
Hope this helps

Thanks for the explanation but no luck. It now says Method or data member not found when I enter:

Please Login or Register  to view this content.

I also tried "test" which is the name of Sheet1 but I think Sheet1 is correct. I am not sure why the startButton is not being recognized. I have selected it and entered "startButton" in the Name Box of Excel. I have also tried the Insert -> Name -> Define method and entered ="startButton" but no luck.

One thing I have noted is that I can't see startButton from the available names in the Name Box. Am I doing Something wrong here?