ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom menu (https://www.excelbanter.com/excel-discussion-misc-queries/69769-custom-menu.html)

winqan

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?

ExcelPower

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