Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003/2007 Compatibility Issue - Hidden Sheets
I have a workbook created in Excel 2003, with a number of hidden
sheets. I need this workbook to also be useable in Excel 2007. Neither the workbook nor the hidden sheets are protected but I can find no way to make the hidden sheets visible in 2007. Before someone replies with Home - Format - Hide & Unhide - Unhide Sheet... I should point out that this menu option is greyed out. If I try to set the Visible property in the VBE to -1 - xlSheetVisible I get the error msg: "Unable to set the Visible property of the Worksheet class". Naturally I get the same msg if I try changing the setting via VBA. Is this a known problem and is there a work-around? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003/2007 Compatibility Issue - Hidden Sheets
It sounds like your workbook's structure is protected.
Check on the Review tab|Changes group (in xl2007) or tools|protection|Unprotect workbook (in xl2003 menus) NickH wrote: I have a workbook created in Excel 2003, with a number of hidden sheets. I need this workbook to also be useable in Excel 2007. Neither the workbook nor the hidden sheets are protected but I can find no way to make the hidden sheets visible in 2007. Before someone replies with Home - Format - Hide & Unhide - Unhide Sheet... I should point out that this menu option is greyed out. If I try to set the Visible property in the VBE to -1 - xlSheetVisible I get the error msg: "Unable to set the Visible property of the Worksheet class". Naturally I get the same msg if I try changing the setting via VBA. Is this a known problem and is there a work-around? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003/2007 Compatibility Issue - Hidden Sheets
As stated - "Neither the workbook nor the hidden sheets are
protected". :-} |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003/2007 Compatibility Issue - Hidden Sheets
Everything you describe strongly suggests the Workbook structure is
protected, as Dave suggested. Might be worth a second look! Regards, Peter T "Nick H" wrote in message ... As stated - "Neither the workbook nor the hidden sheets are protected". :-} |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
2003/2007 Compatibility Issue - Hidden Sheets
Doh! It IS protected!
My apologies Dave. But from the Excel 2007 UI its not obvious - On the Review tab/ribbon in the Changes section there's an icon staring at me saying 'Protect Workbook'. I figured, logically, if the workbook was protected it should say 'Unprotect Workbook'. It was only when I double-checked in the Tools menu on a machine running Excel 2003 that I realised it was actually protected. Sorry for wasting your time. - Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL 2007 COMPATIBILITY MODE ISSUE | Setting up and Configuration of Excel | |||
excel 2007 compatibility issue | Excel Discussion (Misc queries) | |||
Excel 2007 Color Backward-Compatibility Issue | Excel Discussion (Misc queries) | |||
Office 2007 Compatibility Pack issue? | Excel Worksheet Functions | |||
Compatibility Issue between files created in 2003 but opened in 20 | Excel Discussion (Misc queries) |