How do I hide a TAB?
 

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.

How do I hide a TAB?
 

Formatsheethide

--

Regards,

Peo Sjoblom


"Stilla" wrote in message
...
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.

How do I hide a TAB?
 

Try this:
Select the Tab
FormatSheetHide

Is that what you're looking for?

***********
Regards,
Ron


"Stilla" wrote:

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.

How do I hide a TAB?
 

THANKS TO RON & PEO - I feel so DUMB!

"Ron Coderre" wrote:

Try this:
Select the Tab
FormatSheetHide

Is that what you're looking for?

***********
Regards,
Ron


"Stilla" wrote:

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.