How to display all popup menus on right click in excel 97
Posted by Giri on February 03, 2000 1:10 PM
I was able to disable all popup menus using the following code.
For each c in commandbars
if c.position = msobarpopup then
if c.Name <> "MyPopup" then
c.enabled = false
end if
end if
next
This doesn't bring me the popup menus when I right click on the sheet. However, when I right click in the area sorrounding the Toolbar MyPopup it is bringing up the Customize toolbar. I need to disable this feature so that users only exit through my exit button.
Thanks
Giri