How do I hide a TAB?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I hide a tab from view, and retain all its formulas and dependencies on
other sheets?

I have a situation where I need to send a workbook, but don't want people to
mess up anything on the last tab. I tried protecting it, but if I did, the
option buttons on the other sheets can't be clicked. So, if I cannot
protect the last sheet, then I must at least hide it.

I also have a restriction that the file cannot contain any macros.

I'd appreciate any help. Thanks.
 
Try this:
Select the Tab
Format>Sheet>Hide

Is that what you're looking for?

***********
Regards,
Ron
 
THANKS TO RON & PEO - I feel so DUMB!

Ron Coderre said:
Try this:
Select the Tab
Format>Sheet>Hide

Is that what you're looking for?

***********
Regards,
Ron
Click to expand...
 
You must log in or register to reply here.

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

Hide/lock worksheets 4
Excel Move or Copy Stopped Working? 0
How do I hide a tab automatically? 2
How do I set up worksheet tabs to change based on a workbook cell 1
hide columns on a protected sheet 2
code to unhide tabs based on cell contents 7
hiding an image 2
Hide a worksheet 2

Back
Top