Making a Tab Visable
Posted on 2011-10-04
I have an old Workbook (Excel 2007) that I constructed several years ago; In addition to the tab I use to input information/data, I have a hidden tab in the workbook. When I go to my Developer Screen, I can see the tab, but I cannot display it. When I go into the Explorer and change the Xlsheethidden to Xlsheetvisable, it gives me a "Unable to set the visibility to the Worksheet Class" note. Additionally, I cannot add a tab.
Any ideas on how to get it to display the tab? Or change the restriction/setting?