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

  • Thread starter Thread starter sam
  • Start date Start date
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
 
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
 
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

Similar Threads

Excel 2007: Macros not working in password-protected workbooks 2
How to Unlock Excel Workbook protected by MACRO Password 6
xltm saveas xlsm 6
Creating macro enabled Excel 2007 workbook 2
Excel Protection 2
How do I save a paswd protected .xlsm file containing old macros 7
Warning in .xlsm file 3
forwards/backward compatibility Excel 2003-2007 8

Back
Top