Conceal worksheets
 

Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

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

"stew" wrote:

Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

Format/ Sheet/ Hide

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

"Don Guillett" wrote:

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

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" wrote:

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

You must leave, at least, ONE sheet visible.
Is it protected?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Allen McDavitt" wrote in message
...
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" wrote:

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew

Conceal worksheets
 

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

"Don Guillett" wrote:

You must leave, at least, ONE sheet visible.
Is it protected?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Allen McDavitt" wrote in message
...
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" wrote:

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

"stew" wrote in message
...
Is it possible to hide work sheets in Workbook

Thank You

Stew



.