Disable options

  • Thread starter Thread starter Soniya
  • Start date Start date
S

Soniya

Hi All,

How can I disable using Tools>options Menu by users so
that I can protect them making some changes like view
sheet tab etc.

TIA

Soniya
 
Hi Soniya,

This will do it

Application.CommandBars("Worksheet Menu
Bar").Controls("Tools").Controls("Options...").Enabled = False

Reset by wseting to true
--


HTH

Bob Phillips
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TextBox and Time 2
Before Print and UnDo 6
Limit search on visible cells only 1
Count Cells containing Text only 4
Copy to another workbook 1
Sheets Back Up 3
UserForm Caption 2
Default Application.caption 1

Back
Top