| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding A Sheet Command Button With VBA
Worksheets("sheet1").CommandButton1.Visible = False
-- Regards, Tom Ogilvy "Minitman" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Hiding A Sheet Command Button With VBA
Thanks Tom,
That is just what I was looking for. On Sat, 6 Mar 2004 19:35:03 -0500, "Tom Ogilvy" wrote: Worksheets("sheet1").CommandButton1.Visible = False |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use macro(command button) paste special in 2nd sheet | Excel Worksheet Functions | |||
| Command Button Moves when sheet printed | Excel Discussion (Misc queries) | |||
| How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
| Command Button not working once sheet is protected | Excel Programming | |||
| generating sheet with command button & code | Excel Programming | |||
![Minitman[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
