Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Problem
So I have a couple of issues.
I go to open up a file today and try to unhide two worksheets that were hidden, and they are gone. I can still see them in VBA, but cannot open them and they are not visible at all in excel. I also am having trouble inserting a new worksheet. All the options are they, but I am not able to select insert. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Problem
CHeck to see if workbook protection is activated. That would prevent you from
being able to add new sheets (or unhide). Also, in VBE, check to see if the missing sheets have a visible status of "xlSheetVeryHidden". In this state, you can't see the sheet from XL. Change it to either xlSheetVisible or xlSheetHidden. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "dwake" wrote: So I have a couple of issues. I go to open up a file today and try to unhide two worksheets that were hidden, and they are gone. I can still see them in VBA, but cannot open them and they are not visible at all in excel. I also am having trouble inserting a new worksheet. All the options are they, but I am not able to select insert. Any help would be appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Problem
select the sheet in vb, then check the properties (F4) and see what the visible
property is set to. -- Gary Keramidas Excel 2003 "dwake" wrote in message ... So I have a couple of issues. I go to open up a file today and try to unhide two worksheets that were hidden, and they are gone. I can still see them in VBA, but cannot open them and they are not visible at all in excel. I also am having trouble inserting a new worksheet. All the options are they, but I am not able to select insert. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel worksheet problem | Excel Worksheet Functions | |||
Worksheet problem | Excel Worksheet Functions | |||
Worksheet Problem | Excel Discussion (Misc queries) | |||
Worksheet Problem | Excel Worksheet Functions | |||
Worksheet Linking problem | Excel Discussion (Misc queries) |