Removing pasword-protected macro

  • Thread starter Thread starter Arnaud Miege
  • Start date Start date
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
 
Don Guillett said:
Ask the person who "gave" you the file

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
news:%23%[email protected]...
Click to expand...

Not possible, I'm afraid... He was a customer and has left the company he
was working for and I don't have his new contact details.

Arnaud
 
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!
 
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
 
Back
Top