![]() |
custom menu
a custom menu (operated with some macro) always appears when I open the
workbook although I deleted it (or changed its name) before already. How can I pernamently delete it? |
custom menu
Public Sub RemoveCustomMenu() Dim cbWSMenuBar As CommandBar On Error Resume Next Set cbWSMenuBar = CommandBars("Worksheet Menu Bar") cbWSMenuBar.Controls("Menu").Delete End Sub '******************* "Menu" Is the Name of Menu at my place u can replace it by the name given by u with regards Excel Power -- ExcelPower ------------------------------------------------------------------------ ExcelPower's Profile: http://www.excelforum.com/member.php...o&userid=30964 View this thread: http://www.excelforum.com/showthread...hreadid=508847 |
All times are GMT +1. The time now is 12:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com