| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete custom toolbar
Hello,
I need to find out where to delete a custom tool bar. Currently, I delete it in the Before_Close sub of the workbook. The behavior I don't like is when you choose cancel at the save workbook message box the toolbar is deleted. Is there a way to handle the messages from the save dialog box to delete the toolbar only if the workbook is actually closed? thanks bill |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
delete custom toolbar
Try this events
Private Sub Workbook_Activate() End Sub Private Sub Workbook_Deactivate() End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "billQ" wrote in message ... Hello, I need to find out where to delete a custom tool bar. Currently, I delete it in the Before_Close sub of the workbook. The behavior I don't like is when you choose cancel at the save workbook message box the toolbar is deleted. Is there a way to handle the messages from the save dialog box to delete the toolbar only if the workbook is actually closed? thanks bill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom toolbar | Excel Discussion (Misc queries) | |||
| Delete a custom toolbar in excel 2007 from Add-Ins | Setting up and Configuration of Excel | |||
| Custom Toolbar | Excel Discussion (Misc queries) | |||
| How do I permanently delete a custom toolbar in Excel? | Excel Worksheet Functions | |||
| I would like to delete a custom toolbar from the workspace. How? | Setting up and Configuration of Excel | |||
Linear Mode
