View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Specifying a Command Button on a worksheet as differentiated from one on a UserForm

Apparently there was a typo in my original post.

My 2nd suggested form should have been:

Worksheets("Start Here").cmdStartWizard.Enabled = False

Apparently when I edited a copy of the first suggested format, I didn't
remove the Activesheet qualification.

--
Regards,
Tom Ogilvy





"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.22o6eo_1138997408.5922@excelforu m-nospam.com...

Tom,

That's ok, there was a lot going on. Please see the quote below....

I tried your suggestion and I got the error message of "object doesn't
support this property or method" highlighted on the line
"Worksheets("Start Here").ActiveSheet.cmdStartWizard.Enabled = False"
Any advice as to what is going on?


Hope to hear something soon,
Amber :)


Tom Ogilvy Wrote:
As far as I can tell, there are no pending questions in this thread?
What
is unanswered.

--
Regards,
Tom Ogilvy


"Amber_D_Laws"

wrote in message
news:Amber_D_Laws.22npyy_1138976101.2853@excelforu m-nospam.com...

**** Bump ****


--
Amber_D_Laws

------------------------------------------------------------------------
Amber_D_Laws's Profile:

http://www.excelforum.com/member.php...o&userid=30012
View this thread:

http://www.excelforum.com/showthread...hreadid=507754



--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile:

http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=507754