Protect worksheet so user don't have access to TOOLS - OPTIONS

  • Thread starter Thread starter jean
  • Start date Start date
J

jean

Hi

I am trying to protect a workbook and allworksheets.

I know how to do it but the problem is that I want to block the user
on use of Tools - Options (in the menu bar).

thanks

P.S. I am using Excel 2003
 
Not possible. You would have to write macros that remove the Tools menu,
and the user only need not enable macros to prevent them from running.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
Back
Top