| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Bar - make it go away when you change sheets
If the sheet is named "APP_D", then you need to change
CommandBars("Functionality_APP_D").Visible = (Sh.Name = APP_D) to CommandBars("Functionality_APP_D").Visible = (Sh.Name = "APP_D") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Darin Kramer" wrote in message ... Hi Jon, Almost works - just struggling with syntax of last line... CommandBars("Functionality_APP_D").Visible = (Sh.Name = APP_D) What Im doing wrong...?(if my sheet is APP_D) Regards D *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Select All Sheets and Make Change to Footer | Excel Discussion (Misc queries) | |||
| can you make an IF command run a macro??? | Excel Programming | |||
| How to make command buttons move among worksheets? | Excel Programming | |||
| How do I make a command button invisible or visible? | Excel Programming | |||
| Make Command Button visible only in .xlt? | Excel Programming | |||
Threaded Mode
