Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
not able to enable macro in password protected .xlsm workbook.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
not able to enable macro in password protected .xlsm workbook.
On Jul 16, 11:26*am, sam wrote:
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
not able to enable macro in password protected .xlsm workbook.
maybe see this http://support.microsoft.com/kb/927150
"sam" wrote in message ... |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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable code in a password protected worksheet | Excel Discussion (Misc queries) | |||
Excel macro to open a password protected workbook | Excel Discussion (Misc queries) | |||
How do I enable copy in a protected workbook? | Excel Discussion (Misc queries) | |||
vba macro open password protected workbook | Excel Programming | |||
How do I enable autofilter on a protected shared workbook? | Excel Discussion (Misc queries) |