You last visited May 18, 2013, 3:14 am All times shown are Eastern Time (GMT-5:00) | Excel Help Unhide a worksheetEAST COAST, USA United States Member #49886 January 31, 2007 540 Posts Offline | | Posted: June 14, 2012, 4:22 am - IP Logged | |
I am trying to edit a macro and I get an error message saying the I need to "unhide" the workbook using the "unhide" command. Can't seem to get a grip on this? Where exactly do I find the "unhide command?" It's in my Personal Macros Workbook. Thanks for all your help! | | |
ORLANDO, FLORIDA United States Member #5011 June 3, 2004 3497 Posts Offline | | Posted: June 14, 2012, 5:25 am - IP Logged | |
In Excel 07, - On the Home tab, in the Cells group, click Format.

- Under Visibility, click Hide & Unhide, and then click Unhide Sheet.
- In the Unhide sheet box, double-click the name of the hidden sheet that you want to display.
Note You can unhide only one worksheet at a time. | | |
EAST COAST, USA United States Member #49886 January 31, 2007 540 Posts Offline | | Posted: June 17, 2012, 6:43 am - IP Logged | |
CarBob...you are the One! Thanks a Million! Thank You! Thank You! Thank You! I have what seems like 500 macros that i need to delete but couldn't because I had to "unhide a worksheet." The instructions did not say how to unhide it. | | |
5/6 and 8/10 winner 127.0.0.0 Belgium Member #123712 February 27, 2012 1781 Posts Offline | | Posted: June 17, 2012, 7:10 am - IP Logged | |
Press F1 for help. Use the macro recorder recommended by Microsoft. Take a class Excel programming, you seem not to know the basics. | | |
EAST COAST, USA United States Member #49886 January 31, 2007 540 Posts Offline | | Posted: June 17, 2012, 7:57 am - IP Logged | |
Thanks SergeM, I'm just a simple user. I have not really done any programming in Excel. Not until recently. But I did buy a course for Excel. Hopefull this will help. The only problem with the course is that I know most of the basic stuff. It's the programming that i am not that familiar with. | | |
The Ville, FL United States Member #95908 August 19, 2010 1708 Posts Offline | | Posted: June 17, 2012, 9:05 am - IP Logged | |
Or you can just right click on any tab name and select "Unhide" | | |
EAST COAST, USA United States Member #49886 January 31, 2007 540 Posts Offline | | Posted: June 17, 2012, 9:11 am - IP Logged | |
Or you can just right click on any tab name and select "Unhide" thanks a bunch B$Rizzle! | | |
5/6 and 8/10 winner 127.0.0.0 Belgium Member #123712 February 27, 2012 1781 Posts Offline | | Posted: June 17, 2012, 1:00 pm - IP Logged | |
Thanks SergeM, I'm just a simple user. I have not really done any programming in Excel. Not until recently. But I did buy a course for Excel. Hopefull this will help. The only problem with the course is that I know most of the basic stuff. It's the programming that i am not that familiar with. You need to take the advanced course with VBA. It usually is included in a decent course of MS Excel. | | |
|