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
Click to expand...

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
 
Top