edit/delete macro

  • Thread starter Thread starter robhank
  • Start date Start date
R

robhank

on a new workbook, i "stuffed" up a macro & decided to
edit/delete it. i received the following message "cannot
edit a macro on a hidden workbook. unhide the workbook
using the unhide command". i'm confused as i do not have
any hidden workbooks (to my knowledge).
 
Hi

when you record a macro and save it in "personal macro workbook" it gets
saved in a hidden workbook that opens up when you open excel - this way you
can record macros that can be used with multiple workbooks without having to
store the macro in each one of them.

to get to this hidden workbook - choose Window / Unhide and then you'll see
personal.xls in the list, click on it, choose Ok and how you should be able
to delete the macro, once you've done this you should hide personal.xls
again (window / hide - while in personal.xls)

Hope this helps

Cheers
Julie
 
Back
Top