Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lost ability to see worksheets
All
A critical workbook stopped showing its three worksheets...I just got the workbook without any sheets showing. Amazingly, I could view the sheets with Web Page Review. My solution wasn't pretty. I used Object Rexx's Office Automation capablity bring up the offending workbook and then set each sheet as current. I then used Copy/Move Sheet to export each sheet to a new workbook. Excel 2002, Win2K Q1: Is the loss of seeing worksheets a know problem? Q2: Can this type of problem be solved without going into VBA or Office Automation? REX |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
lost ability to see worksheets
They are prolly just hidden (perhaps a macro is pressent that hides the sheets!)
Open VB (Alt+F11) Press Ctrl+R (to view Project explorer - may already be open!) Select the sheet you want from the TREE in the Project explorer Press F4 (to goto the property window) Set the Visible property to 1 - xlSheetVisible If need be, you can add a simple macro that shows all sheets when the book is opened... In "ThisWorkbook" add the following... Private Sub Workbook_Open() Sheet1.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Sheet3.Visible = xlSheetVisible End Sub be sure to set the Sheet names correctly for your work book. "T-Rex" wrote in message ... All A critical workbook stopped showing its three worksheets...I just got the workbook without any sheets showing. Amazingly, I could view the sheets with Web Page Review. My solution wasn't pretty. I used Object Rexx's Office Automation capablity bring up the offending workbook and then set each sheet as current. I then used Copy/Move Sheet to export each sheet to a new workbook. Excel 2002, Win2K Q1: Is the loss of seeing worksheets a know problem? Q2: Can this type of problem be solved without going into VBA or Office Automation? REX |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
lost ability to see worksheets
I don't think all the worksheets can be hidden; at least one has to be
visible. -- Vasant "Stevie_mac" wrote in message ... They are prolly just hidden (perhaps a macro is pressent that hides the sheets!) Open VB (Alt+F11) Press Ctrl+R (to view Project explorer - may already be open!) Select the sheet you want from the TREE in the Project explorer Press F4 (to goto the property window) Set the Visible property to 1 - xlSheetVisible If need be, you can add a simple macro that shows all sheets when the book is opened... In "ThisWorkbook" add the following... Private Sub Workbook_Open() Sheet1.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Sheet3.Visible = xlSheetVisible End Sub be sure to set the Sheet names correctly for your work book. "T-Rex" wrote in message ... All A critical workbook stopped showing its three worksheets...I just got the workbook without any sheets showing. Amazingly, I could view the sheets with Web Page Review. My solution wasn't pretty. I used Object Rexx's Office Automation capablity bring up the offending workbook and then set each sheet as current. I then used Copy/Move Sheet to export each sheet to a new workbook. Excel 2002, Win2K Q1: Is the loss of seeing worksheets a know problem? Q2: Can this type of problem be solved without going into VBA or Office Automation? REX |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
lost ability to see worksheets
This is true, but he does appear to have a problem.
I was gonna suggest he investigates via the immediate window - but just decided to offer a quick solution (ofcourse I'm assuming the Visible property is false) "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... I don't think all the worksheets can be hidden; at least one has to be visible. -- Vasant "Stevie_mac" wrote in message ... They are prolly just hidden (perhaps a macro is pressent that hides the sheets!) Open VB (Alt+F11) Press Ctrl+R (to view Project explorer - may already be open!) Select the sheet you want from the TREE in the Project explorer Press F4 (to goto the property window) Set the Visible property to 1 - xlSheetVisible If need be, you can add a simple macro that shows all sheets when the book is opened... In "ThisWorkbook" add the following... Private Sub Workbook_Open() Sheet1.Visible = xlSheetVisible Sheet2.Visible = xlSheetVisible Sheet3.Visible = xlSheetVisible End Sub be sure to set the Sheet names correctly for your work book. "T-Rex" wrote in message ... All A critical workbook stopped showing its three worksheets...I just got the workbook without any sheets showing. Amazingly, I could view the sheets with Web Page Review. My solution wasn't pretty. I used Object Rexx's Office Automation capablity bring up the offending workbook and then set each sheet as current. I then used Copy/Move Sheet to export each sheet to a new workbook. Excel 2002, Win2K Q1: Is the loss of seeing worksheets a know problem? Q2: Can this type of problem be solved without going into VBA or Office Automation? REX |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lost ability to sort by color | Excel Discussion (Misc queries) | |||
lost ability to filter by color | Excel Discussion (Misc queries) | |||
I have lost the ability to auto Sum my columns.... | Excel Worksheet Functions | |||
I have lost the ability to auto Sum... | Excel Worksheet Functions | |||
Lost Ability To Calculate Workdays | Excel Discussion (Misc queries) |