Unhide macro worksheet
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 |
Unhide macro worksheet
hi
the command to unhide the sheet.... 2003 on the menu barformatsheetunhide 2007 Home tabcells groupHide&hideunhide 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 |
Unhide macro worksheet
Personal.xls is a workBOOK, not a workSHEET.
To unhide a workbook, go to WindowsUnhide. Or in 2007 go to ViewUnhide 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, |
All times are GMT +1. The time now is 03:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com