Disable options

Soniya · Aug 3, 2003

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 · Aug 3, 2003

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