Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command Bar show/hide/delete
Quick question:
I have a custom command bar that I want to show always and only with a specific worksheet in a specific workbook. In "This Workbook" macro area I have Private Sub Workbook_Activate Application.CommandBars("MyCommandBar").Visible = True End Sub Private Sub Workbook_Deactivate Application.CommandBars("MyCommandBar").Visible = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.CommandBars("MyCommandBar").Delete End Sub (I also have visible true/false to activate and deactivate the sheet, but that is not where I seem to be having trouble) Upon closing the workbook I get an error message: "Invalid Procedure Call or Argument" that goes to the workbook_deactivate code when I hit "debug". But if I delete that part out then I can still see the command bar upon opening (and activating) another workbook, although the error message is gone. Help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Button to show/hide a different worksheet | Excel Discussion (Misc queries) | |||
Hide Show Command Buttons | Excel Programming | |||
Hide command button | Excel Programming | |||
How do I hide 5 command buttons | Excel Programming | |||
Hide Row command using if statement | Excel Worksheet Functions |