Disable options

[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

 

[Bob Phillips]

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