not able to enable macro in password protected .xlsm workbook.

S

sam

I am not able to enable macro in password protected *.xlsm file.. Once i
remove the password from protected workbook, I can run the macro..
Is there a way I can keep the password and still enable the macro?

Please Help!

Thanks in Advance
 
G

gab1972

I am not able to enable macro in password protected *.xlsm file.. Once i
remove the password from protected workbook, I can run the macro..
Is there a way I can keep the password and still enable the macro?

Please Help!

Thanks in Advance

Why not unprotect the sheet through VBA, run coding, then protect the
sheet again?

ActiveWorkbook.Sheets("Status").Unprotect
'coding here'
ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True
 
H

Homey

maybe see this http://support.microsoft.com/kb/927150

|I am not able to enable macro in password protected *.xlsm file.. Once i
| remove the password from protected workbook, I can run the macro..
| Is there a way I can keep the password and still enable the macro?
|
| Please Help!
|
| Thanks in Advance
 

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

Top