Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make excel hide columns when it says cannot move objects | Excel Discussion (Misc queries) | |||
hide toolbars, menu bar, etc | Excel Discussion (Misc queries) | |||
hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
How Do I Hide A Row (if a condition is true) using a Macro ? | Excel Worksheet Functions | |||
Hide AutoShapes On Excel Worksheet | Excel Worksheet Functions |