Difficult Time/ Deleting Macro/ Tool Bar

  • Thread starter Thread starter John
  • Start date Start date
J

John

In deleting a macro my steps are: 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.
 
You don't have to unhide Personal.xls in order to delete macros from that
workbook.

Tools>Macro>Macros 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
 
Back
Top