my personal worksheet with all my macros is hidden and I am unable to unhide it - can anyone assist?
C cristine Jun 26, 2009 #1 my personal worksheet with all my macros is hidden and I am unable to unhide it - can anyone assist?
M Mike H Jun 26, 2009 #2 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
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
G Gord Dibben Jun 26, 2009 #3 Macros live in a module in Personal.xls I think you mean your workbook is hidden. Try Window>Unhide Gord Dibben MS Excel MVP
Macros live in a module in Personal.xls I think you mean your workbook is hidden. Try Window>Unhide Gord Dibben MS Excel MVP
C cristine Jun 26, 2009 #4 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
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