| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conceal worksheets
Is it possible to hide work sheets in Workbook
Thank You Stew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I conceal the unused range from the scroll bar? | Excel Discussion (Misc queries) | |||
| How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
| how do i copy a cell in worksheets 10 to the other 9 worksheets | New Users to Excel | |||
| How do i assign the ActiveWorkbook.Worksheets to a worksheets object? | Excel Worksheet Functions | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
Linear Mode
