Disabling menus etc

[DonB]

I am sure this must have been covered several times
before, but can someone tell me how to disable menus,
tools etc, to prevent workbooks being tampered with.
Disabling tooklbars is not a problem

Many thanks

DonB

 

[keepitcool]

Don,

Generally your user's will definitely NOT like it when you start messing
with their menu's and/or toolbars... else your code must be 110%
bulletproof to RESET their menu's on errors/close etc...

I think using the worksheet's protection with UserInterFaceonly = true is
the best way to go.

See vba help on Protect method (as applies to Worksheet)


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Bob Phillips]

Don,

It is the same way, a menu is just a commandbar as a toolbar is.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)