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

[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

 

[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

 

[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