Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Sheet, Hide Sheet
How can I hide a sheet once I have created it.
I have done:- newSheet = "Sheet 1" Sheets.Add.Name = newSheet How do I then hide this sheet? Thanks! Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Sheet, Hide Sheet
Activesheet.Visible = xlSheetHidden
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave" wrote in message ... How can I hide a sheet once I have created it. I have done:- newSheet = "Sheet 1" Sheets.Add.Name = newSheet How do I then hide this sheet? Thanks! Dave |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Sheet, Hide Sheet
or
Worksheets(newSheet).Visible = xlSheetHidden -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Dave" wrote in message ... How can I hide a sheet once I have created it. I have done:- newSheet = "Sheet 1" Sheets.Add.Name = newSheet How do I then hide this sheet? Thanks! Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
hide sheet | Excel Discussion (Misc queries) | |||
How to create a formala in one sheet for a cell in another sheet? | Excel Worksheet Functions | |||
Create a sheet name, won't let me, says already sheet named that | Excel Worksheet Functions | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions |