Cancel Toolbar load

[Gordon]

Hi...

I'm building a visual basic project in excel and I don't want any toolbars
loading. I can make the Excel toolbars not load, but wouldn't know whether a
user has adobe or 3rd party etc toolbars in the excel build. Is there a line
of code that will mean that no toolbars at all are loaded?

Also, I knew this before, but how do you disable the right click in a
worksheet?

Thanks

Gordon.

 

[Peter T]

There's not a single code line to prevent toolbars from loading. You could
loop non popup bars and make them not visible, but I'd urge you not to do
that. Try Full screen instead.

To disable the right click popup, in the Workbook_SheetBeforeRight or
Worksheet_BeforeRightClick event
Cancel = True

Regards,
Peter T