hide worksheet tabs

D

Dave Peterson

In xl2003:
Tools|Options|view tab|uncheck sheet tabs

Be aware that the user can use ctrl-pgup and ctrl-pgdn to move between sheets.
 
R

Roxy

Oh okay thanks. I am trying to use a contol button to allow users to unhide
the specific sheet. Do you think that is possible rather then just changing
the sheet option? Thanks!
 
D

Dave Peterson

Sure.

You can protect the workbook ("tools|protection|protect workbook" manually).
This will stop the user from moving, deleting, inserting, hiding, unhiding
sheets.

Then your code could unprotect the workbook, unhide the worksheet, and then
reprotect the worksheet.
 

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

Open Specific Worksheet Using Button Form Control in Excel 0
Loop to hide sheet based on cell 1
How to hide xls worksheet tabs (Vista) 3
hide and unhde worksheets when a set button on a form is clicked 1
Hiding the Insert New Worksheet tab in Excel 2007 3
hide colum based on cell value on each worksheets 2
Word Customize Ribbon In Word 2007 1
Hide worksheet tab 1

Top