View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

you could look under tools / macro / macros and choose "this workbook" from
the "IN" drop down box at the bottom of the screen ... if it is a macro
stored in a normal module ... if you can't find it there, press ALT & F11 to
switch to the VBE Window, down the left you should see the project explorer
(view / project explorer) with the name of your workbook in bold, under this
you'll see sheet1, sheet2 etc and then thisworkbook - the macro could also
live in any of these places, so double click on each in turn - any macros in
them will show up on the right hand side of the screen

Cheers
JulieD

"LLEECEE" wrote in message
...
I have an Excel file created by someone else that announces a macro when
opened. How do find the macro to decide to use or delete it? I do not
know
its name.