Difficult Time/ Deleting Macro/ Tool Bar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 06 Dec 2007 15:00 GMT

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?

Reply to this Message

Luke M - 06 Dec 2007 15:22 GMT

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.

Signature

Best Regards,

Luke M

> 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?

Reply to this Message

Gord Dibben - 06 Dec 2007 16:30 GMT

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

>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?

Reply to this Message

Rate this thread: