 |
| |||
|
Excel 2007 Compatibility How to unhide worksheet When opening a 2003 version of an Excel Spreadsheet in Excel 2007 I could reference but not unhide a sheet To solve the problem I just kept a copy of the spreadsheet with the Hidden Sheet shown and reverted back to this one whenever a change was made. It would not allow me to save as a Macro Enabled workbook as it contained version 3.0 and 4.0 Macros I finally solved a method of unprotecting the worksheet structure and displaying the hidden worksheet as follows:- 1. Click on the Review Tab 2. Click on Protect Workbook 3. Untick the Protect Structure and Window 
4. Enter the password 5. Now right Click on a visible worksheet at the bottom 
6. Click OK 7. Select the hidden worksheet by clicking on it and click show 
IP | ||||
|
||||