my xlSheetVeryHidden is hidden and I can't unhide it - HELP!
my personal worksheet with all my macros is hidden and I am unable to unhide
it - can anyone assist? |
Answer: my xlSheetVeryHidden is hidden and I can't unhide it - HELP!
Here's how you can unhide your very hidden worksheet in Excel:
As for your personal worksheet with macros, you can unhide it using the same steps above. If it's still not visible, make sure you're looking in the correct workbook and that the sheet is not protected. If it is protected, you'll need to unprotect it before you can unhide it. |
my xlSheetVeryHidden is hidden and I can't unhide it - HELP!
Hi,
If it's XlVeryHidden then you need to unhide from the VB editor ALT+F11 t open VB editor. Tap F4 to open the properties window Select your very hiiden sheet in Project Explorer and change the visible property from XlveryHidden to Visible. Mike "cristine" wrote: my personal worksheet with all my macros is hidden and I am unable to unhide it - can anyone assist? |
my xlSheetVeryHidden is hidden and I can't unhide it - HELP!
Macros live in a module in Personal.xls
I think you mean your workbook is hidden. Try WindowUnhide Gord Dibben MS Excel MVP On Fri, 26 Jun 2009 11:47:01 -0700, cristine wrote: my personal worksheet with all my macros is hidden and I am unable to unhide it - can anyone assist? |
my xlSheetVeryHidden is hidden and I can't unhide it - HELP!
Thanks Gord, I tried that and unhide was greyed out. So I shut down the
system and when I opened excel my Personal.xls opened. Thanks for the help "Gord Dibben" wrote: Macros live in a module in Personal.xls I think you mean your workbook is hidden. Try WindowUnhide Gord Dibben MS Excel MVP On Fri, 26 Jun 2009 11:47:01 -0700, cristine wrote: my personal worksheet with all my macros is hidden and I am unable to unhide it - can anyone assist? |
All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com