Posted to microsoft.public.excel.programming
|
|
Disable Right Clicking of Excel logo on Standard menu Bar
Hi Peter
See this page
http://www.rondebruin.com/menuid.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Peter Rooney" wrote in message ...
Thanks, Ron, that worked just fine.
Are there any ways in which I can disable the other commands on the shortcut
menu to, for instance, prevent the creation of a new workbook?
Regards
Pete
"Ron de Bruin" wrote:
Hi Peter
It is easier to protect the VBA code with a password
In the VBA editor go to ToolsVBA project properties
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Peter Rooney" wrote in message
...
Good afternoon, all,
I want to be able to prevent users from viewing my code. I've already
disabled Alt-F11 using application.onkey, but they can still get to it by
right clicking the Excel logo on the Standard Menu Bar. Is there any way in
which I can reference this as an object, to either disable it or remove it
from the menu bar?
Thanks in advance
Pete
|