Prev: Custom format Numbers
Next: reduce size ribbon
From: JoeF on 4 Mar 2010 14:25
I have created a macro in my personal.xls worksheet. I want to delete the
macro but am getting a message that I need to unhide the worksheet. I cannot
locate the worksheet where the macro is stored and cannot find the command to
unhide it. Help!!!

Thank you very much,
--
JoeF
From: FSt1 on 4 Mar 2010 15:29
hi
the command to unhide the sheet....
2003
on the menu bar>format>sheet>unhide
2007
Home tab>cells group>Hide&hide>unhide sheet

regards
FSt1

"JoeF" wrote:

> I have created a macro in my personal.xls worksheet. I want to delete the
> macro but am getting a message that I need to unhide the worksheet. I cannot
> locate the worksheet where the macro is stored and cannot find the command to
> unhide it. Help!!!
>
> Thank you very much,
> --
> JoeF
From: Gord Dibben on 4 Mar 2010 16:10
Personal.xls is a workBOOK, not a workSHEET.

To unhide a workbook, go to Windows>Unhide.

Or in 2007 go to View>Unhide

Easier yet is to Alt + F11 to open VBE.

Locate Personal.xls and expand.

Double-click on Module1 to open it.

Find your macro and delete it.


Gord Dibben MS Excel MVP

On Thu, 4 Mar 2010 11:25:01 -0800, JoeF <JoeF(a)discussions.microsoft.com>
wrote:

>I have created a macro in my personal.xls worksheet. I want to delete the
>macro but am getting a message that I need to unhide the worksheet. I cannot
>locate the worksheet where the macro is stored and cannot find the command to
>unhide it. Help!!!
>
>Thank you very much,

 | 
Pages: 1
Prev: Custom format Numbers
Next: reduce size ribbon