S
stew
Is it possible to hide work sheets in Workbook
Thank You
Stew
Thank You
Stew
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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
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
D
David Biddulph
Format/ Sheet/ Hide
Doesn't Excel help tell you when you type in the words: hide worksheet?
Doesn't Excel help tell you when you type in the words: hide worksheet?
D
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
macro to hide
sheets("yoursheetnamehere").visible=xlveryhidden
to unhide
..visible=true
A
Allen McDavitt
Don Guillett said: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)
A
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?
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?
D
Don Guillett
You must leave, at least, ONE sheet visible.
Is it protected?
Is it protected?
A
Allen McDavitt
You are correct when I added another sheet then I was able to hide the sheet
I wanted to hide. Thanks
I wanted to hide. Thanks