Tools menu

G

Guest

I have hidden the sheet tabs in a worksheet using the 'tools' - 'options'
menu. Is there any way of preventing a user simply un-hiding the sheet tabs.

Mike
 
P

paul.robinson

Hi
Protect the workwook would be easiest (tools, Protection, Workbook).
Users won't be able to create sheets though.
regards
Paul
 
W

WhytheQ

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

Rgds
J
 

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

protecting sheet tabs 11
hide and unhde worksheets when a set button on a form is clicked 1
Locking Sheet Tabs as Hidden 7
tabs in webpage 1
HOW TO REMOVE 'SHEET TABS' FROM OPTIONS MENU IN VB 3
list of workbook tabs 6
Custom filter 26
Sheet Order _ Numbering 7

Top