One way is to modify the command bar, disabling the item. Don't have the
code at hand but have done this in the past.


"Ted" wrote:

A small problem ...
I know how to set Sheet Tabs to be hidden in VBA but I can't see how I can
stop the user from going to the Tools-- Options menu and unhiding them
(which makes hiding them a bit pointless).
What am I missing?
Thanks in advance

Ted