Removing pasword-protected macro

A

Arnaud Miege

Hi,

I have been given spreadsheet (in Excel 2007) that contains a macro. I would
like to remove it from the spreadsheet, but it's password-protected and I
don't have access to the password. Is there any way to delete that macro
without knowing the password?

Thanks in advance,

Arnaud
 
R

Ray

If you save the file as .xlsx (XL07 only), it should delete the macro
automatically. Keep in mind that ALL macros/procedures/etc will be
deleted by doing this, so if you only want to delete one macro (and
keep others), DO NOT use this method!
 
A

Arnaud Miege

Ray said:
If you save the file as .xlsx (XL07 only), it should delete the macro
automatically. Keep in mind that ALL macros/procedures/etc will be
deleted by doing this, so if you only want to delete one macro (and
keep others), DO NOT use this method!
Click to expand...
Thank you, I'll give it a try. There's only one macro, but I want to remove
all macros so that's OK.

Arnaud
 
Top