Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Answer to my own question:
Here's what I did: Earlier when I posed my question, the macro I refered to in order t test code validity was named Delete (how original!)...code as follows: Sub Delete() Dim cbWSMenuBar As CommandBar On Error Resume Next Set cbWSMenuBar = CommandBars("Worksheet Menu Bar") cbWSMenuBar.Controls("Britannia").Delete End Sub the BeforeClose sub now looks like the following: Private Sub Workbook_BeforeClose(Cancel As Boolean) Call Delete End Sub Works just fine. Hope this helps someone. Ro -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
custom command | Excel Discussion (Misc queries) | |||
Custom Command Bars | Excel Discussion (Misc queries) | |||
Preventing Users from Modifying Custom Command Bars | Excel Programming | |||
Embed Graphic onto custom command | Excel Programming | |||
Macro as Custom Menu Command | Excel Programming |