De-Macroing Excel Files

  • Thread starter Thread starter Dave W.
  • Start date Start date
D

Dave W.

Hi group, hope someone can help. I mistakenly recorded a simple macro to the
active workbook instead of 'Personal.xls'. Now, of course, the macro virus
warning pops up every time this file opens (and I know my boss will not be
impressed as he considers macros to be black magic). Deleting the macro did
not fix it.
Is there any way to return an Excel file to its pre-macro state?

Hopefully,
Dave W.
 
Hi dave

FIRST, MAKE SURE YOU ARE VERY CAREFUL AND DO NOT DELETE ANY MACROS YOU WANT TO KEEP!

You will need to go into the VBA editor. In XL, on your keyboard, hold down ALT and press F11. This will take you to the
VBA editor.

Double-click on the "VBAProject Personal.xls' item in the Projector Explorer on the left-hand side; double-click the
modules that display below it. Double-click on the module that your macro was in.

Make ABSOLUTELY CERTAIN you are dealing with the correct module, then from the File menu, choose "Remove Module". Read
the next box carefully and you will probably click "No".

This will have stopped the black magic happening.


hth

Steve

Hi group, hope someone can help. I mistakenly recorded a simple macro to the
active workbook instead of 'Personal.xls'. Now, of course, the macro virus
warning pops up every time this file opens (and I know my boss will not be
impressed as he considers macros to be black magic). Deleting the macro did
not fix it.
Is there any way to return an Excel file to its pre-macro state?

Hopefully,
Dave W.
Click to expand...

remove "_ILY_" to email me

email to (e-mail address removed)
 
Works a treat !
Thank you Steve, much appreciated.

Dave W.

Stephen Simons said:
Hi dave

FIRST, MAKE SURE YOU ARE VERY CAREFUL AND DO NOT DELETE ANY MACROS YOU WANT TO KEEP!

You will need to go into the VBA editor. In XL, on your keyboard, hold
Click to expand...
down ALT and press F11. This will take you to the
VBA editor.

Double-click on the "VBAProject Personal.xls' item in the Projector
Click to expand...
Explorer on the left-hand side; double-click the
modules that display below it. Double-click on the module that your macro was in.

Make ABSOLUTELY CERTAIN you are dealing with the correct module, then from
Click to expand...
the File menu, choose "Remove Module". Read
 
Back
Top