Conceal worksheets

[stew]

Is it possible to hide work sheets in Workbook

Thank You

Stew

 

[Mike H]

Hi,

Yes it is but you can't hide them all, you must have 1 visible sheet at least.

For Excel 2007

Format|Sheet - Hide

Mike

 

[David Biddulph]

Format/ Sheet/ Hide

Doesn't Excel help tell you when you type in the words: hide worksheet?

 

[Don Guillett]

IF? you don't want your users to be able to unhide withOUT a macro use a
macro to hide
sheets("yoursheetnamehere").visible=xlveryhidden
to unhide
..visible=true

 

[Allen McDavitt]

IF? you don't want your users to be able to unhide withOUT a macro use a
macro to hide
sheets("yoursheetnamehere").visible=xlveryhidden
to unhide
..visible=true
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Allen McDavitt]

I have created a procedure with the hide command from Don Guillett, however
when I run it I get run-time error '1004': Unable to set the Visible
property of the Worksheet class. How do I deal with this issue?

 

[Don Guillett]

You must leave, at least, ONE sheet visible.
Is it protected?

 

[Allen McDavitt]

You are correct when I added another sheet then I was able to hide the sheet
I wanted to hide. Thanks