Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 06:04 PM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default 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   Report Post  
Old December 12th 05, 06:10 PM posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Old December 12th 05, 06:16 PM posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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   Report Post  
Old December 12th 05, 06:20 PM posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make excel hide columns when it says cannot move objects Dale Excel Discussion (Misc queries) 0 November 10th 05 03:44 PM
hide toolbars, menu bar, etc runandrun Excel Discussion (Misc queries) 0 September 22nd 05 10:16 PM
hide a worksheet so that a macro can still find it frendabrenda1 Excel Worksheet Functions 1 June 17th 05 04:30 PM
How Do I Hide A Row (if a condition is true) using a Macro ? Anthony Fantone Excel Worksheet Functions 1 June 16th 05 04:54 PM
Hide AutoShapes On Excel Worksheet Dave Y Excel Worksheet Functions 5 June 12th 05 04:26 AM


All times are GMT +1. The time now is 12:03 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017