![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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 |
| Ads |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 > 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, |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Unhide the next worksheet | MarkSussex | Excel Discussion (Misc queries) | 1 | July 28th 09 08:27 PM |
| macro to unhide a sheet | Bill_S | Excel Discussion (Misc queries) | 1 | April 10th 08 05:27 PM |
| Unhide worksheet IF | Marilyn | Excel Discussion (Misc queries) | 7 | April 4th 08 10:35 PM |
| unhide a row in a worksheet using vba | Roxy | Excel Discussion (Misc queries) | 2 | February 1st 08 12:41 AM |
| how do i unhide a worksheet in excel 2003? unhide tab don't work | mikekeat | Excel Discussion (Misc queries) | 2 | March 6th 06 03:36 AM |