Hidding worksheets

grev

New Member
Joined
Sep 4, 2002
Messages
21
Is there any way I can hide several worksheets in a workbook? I have one worksheet I want to make public, but I do not want anyone seeing the surrounding worksheets. Is this possible?
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Non basic - Format Sheets Hide

Through VB

Sheets("sheetname").visible = false

repeat as necessary.
 
Upvote 0
I am sorry but can you walk me through this. Do I go in visual basic, which I did (not very familiar with it) and type in format sheets...

Maybe I am missing something. Thanks for the help.
 
Upvote 0
As Juan Pablo suggested, without Visual Basic:
select the sheet you want to hide;
from the menubar select Format->Sheets->Hide;
repeat this for every sheet you want to hide.
 
Upvote 0
I need to hide several sheets often as well so "regular" users can't change formulas, etc.

However, when I need to make edits to those hidden sheets, I can't un-hide several sheets at once. The list of hidden sheets appears, but holding CTRL or SHIFT won't highlight more than one at a time.

Annoying when you need to do this on 10-12 sheets!

Anyone?
 
Upvote 0
On 2002-09-10 11:59, Galto wrote:
I need to hide several sheets often as well so "regular" users can't change formulas, etc.

However, when I need to make edits to those hidden sheets, I can't un-hide several sheets at once. The list of hidden sheets appears, but holding CTRL or SHIFT won't highlight more than one at a time.

Annoying when you need to do this on 10-12 sheets!

Anyone?

You can record a macro while performing the hide operation.
Create a macro too for unhiding.
Next time you want to hide or unhide you only have to run the corresponding macro.
 
Upvote 0
rikrak,

Thanks for your suggestion. I guess it should have been kind of obvious 'round here, huh?

:razz:
 
Upvote 0

Forum statistics

Threads
1,223,192
Messages
6,170,647
Members
452,344
Latest member
LarryRSch

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top