How do you .DELETE a (sub-menu) Control that was clicked?
In a nutshell, when I click on the menu sub-item "Exit Admin Mode" all the
sub-items are deleted EXCEPT the "Exit Admin Mode" sub-item. If I step through the BuildMoreMenus() routine it WILL delete all sub-items if they are present, including the "Exit Admin Mode" sub-item. Very odd. How can I have that sub-item deleted when I click it? Here's the code that creates and deletes the Help menu sub-items: Code:
Public Const DATA_MENU_ID As Long = 30010 'Help main menu item Code:
Private Sub BuildMoreMenus() |
How do you .DELETE a (sub-menu) Control that was clicked?
Why not create the menu in the workbook_open event and delete the
menu in the workbook_close event? Problem would be solved. -or- You could add a button from the Forms toolbar to the sheet at the same time that you create the menu. The button could delete itself after removing the sub-menus. I use that technique in my "List Files" add-in. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Air_Cooled_Nut" wrote in message In a nutshell, when I click on the menu sub-item "Exit Admin Mode" all the sub-items are deleted EXCEPT the "Exit Admin Mode" sub-item. If I step through the BuildMoreMenus() routine it WILL delete all sub-items if they are present, including the "Exit Admin Mode" sub-item. Very odd. How can I have that sub-item deleted when I click it? Here's the code that creates and deletes the Help menu sub-items: Code:
Public Const DATA_MENU_ID As Long = 30010 'Help main menu item Code:
Private Sub BuildMoreMenus() |
How do you .DELETE a (sub-menu) Control that was clicked?
I already do that and that's not what I'm asking about.
When I click on the menu sub-item "Exit Admin Mode" all the sub-items are deleted EXCEPT the "Exit Admin Mode" sub-item. I still am in the workbook and still using it, the Admin Mode can be toggled on or off during the use of the workbook. How can I have that sub-item deleted ("Exit Admin Mode") *when it is clicked*? "Jim Cone" wrote: Why not create the menu in the workbook_open event and delete the menu in the workbook_close event? Problem would be solved. -or- You could add a button from the Forms toolbar to the sheet at the same time that you create the menu. The button could delete itself after removing the sub-menus. I use that technique in my "List Files" add-in. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Air_Cooled_Nut" wrote in message In a nutshell, when I click on the menu sub-item "Exit Admin Mode" all the sub-items are deleted EXCEPT the "Exit Admin Mode" sub-item. If I step through the BuildMoreMenus() routine it WILL delete all sub-items if they are present, including the "Exit Admin Mode" sub-item. Very odd. How can I have that sub-item deleted when I click it? Here's the code that creates and deletes the Help menu sub-items: Code:
Public Const DATA_MENU_ID As Long = 30010 'Help main menu item Code:
Private Sub BuildMoreMenus() |
All times are GMT +1. The time now is 01:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com