Thread: Hiding A Sheet Command Button With VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Minitman[_3_] Minitman[_3_] is offline
external usenet poster
  
Posts: 3
Default Hiding A Sheet Command Button With VBA
Greetings,

I have a Command Button on a worksheet than under some conditions
needs to be hidden. I am trying to hide it from a UserForm. I have
tried:

CommandButton1.Visible = False

In the code to start the next procedure, I get this message in a
"Microsoft Visual Basic" message box:

Compile Error:
Variable not defined

Any suggestions?

TIA

-Minitman


Reply With QuoteReply With Quote