In deleting a macro my steps a Tools--Macro--Macro-- select Personal.XLS
in Macros Dialog Box. Then Unhide Personal Workbook by choosing Windows on
the tool bar, then selecting unhide on the drop down and clicking O.K. to
the dialog box. Then Tools---Macros--Macros again. Highlight the Macro
click delete. During this process Unhide does not appear highlighted on the
Windows drop down. Some how trouble shoot this situation?

You could delete the macro from the VBA editor. Simply press Alt+F11, then in
the navigation window select your personal workbook. Find the macro you want
to delete, highlight of all it, and delete.
--
Best Regards,

Luke M


"John" wrote:

In deleting a macro my steps a Tools--Macro--Macro-- select Personal.XLS
in Macros Dialog Box. Then Unhide Personal Workbook by choosing Windows on
the tool bar, then selecting unhide on the drop down and clicking O.K. to
the dialog box. Then Tools---Macros--Macros again. Highlight the Macro
click delete. During this process Unhide does not appear highlighted on the
Windows drop down. Some how trouble shoot this situation?

You don't have to unhide Personal.xls in order to delete macros from that
workbook.

ToolsMacroMacros will show macros from all open workbooks(unless they are
Privare Subs)

Select the one(s) to delete and delete.


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 07:00:01 -0800, John wrote:

In deleting a macro my steps a Tools--Macro--Macro-- select Personal.XLS
in Macros Dialog Box. Then Unhide Personal Workbook by choosing Windows on
the tool bar, then selecting unhide on the drop down and clicking O.K. to
the dialog box. Then Tools---Macros--Macros again. Highlight the Macro
click delete. During this process Unhide does not appear highlighted on the
Windows drop down. Some how trouble shoot this situation?