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



Posted by Celia on February 03, 2000 3:46 PM


Giri

Try adding the following :

CommandBars("Toolbar List").Enabled = False

Celia