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
 
A

Arnaud Miege

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

including macro in protected worksheet 2
How to Unlock Excel Workbook protected by MACRO Password 6
Copying in sheet with protection with the use of a macro 5
not able to enable macro in password protected .xlsm workbook. 2
how to open a password protected powerpoint file by Excel 1
Excel Protection 2
How to open a password protected powerpoint file by Excel macro 2
Open password protected file with macros 2

Top