| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Resetting menu option on close...
Did you create a custom toolbar names "Sheet"?
-- Regards, Tom Ogilvy "alanleecohen" wrote in message ... I use a Usrform to logon and to prevent unhiding sheets i use the following code - CommandBars("Sheet").Enabled = True. However when I close the workbook the same code (that i've placed in the ThisWOrkbook Workbook_Before_Closed event gives me the following error... Error '91" Object variable or With block not set... What am I missing...:)? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a Close Workspace option when right-clicking Excel in taskb | Setting up and Configuration of Excel | |||
| close email option | Excel Discussion (Misc queries) | |||
| Option in Excel to save a close a workbook inactive for 5 minutes | Excel Discussion (Misc queries) | |||
| Resetting Excel commandbars on close event | Excel Programming | |||
| Resetting Menu Bars in Visual Basic | Excel Programming | |||
Linear Mode
