| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros and Passwords
When i attached a password to a file with a macro I get a security warning
and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
What version of Excel are you using? What *exactly* does the error message
say? What is you VBA Macro Security setting? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
I'm using office 2007, the message bar says: security warning: macros have
been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
In Excel 2007, there are two different files formats. This is different than
2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
Yes i know. I saved it in "xlsm" format but the macro will only work if i
remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
--------------------------------------------------------------------------------------------------
Posted by Jim Reach. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan set to 1. ----------------------------------------------------------------------------------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Office Menu-2003 for Office-2007) If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Shawrie777" wrote in message ... Yes i know. I saved it in "xlsm" format but the macro will only work if i remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
I have the EXACT same situation. How ridiculous that Microsoft does not in
anyway warn about this. I have wasted about 4 hours today trying to figure this out. Thank you for this post though. At least I know now I am not going crazy. -- Randy "Shah Shailesh" wrote: -------------------------------------------------------------------------------------------------- Posted by Jim Reach. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan set to 1. ----------------------------------------------------------------------------------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Office Menu-2003 for Office-2007) If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Shawrie777" wrote in message ... Yes i know. I saved it in "xlsm" format but the macro will only work if i remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
Can you tell me how to save an excel 2007 file without password protection?
The file was originally created in excel 2003 and the password was inherited. I can't get rid of the password and until I do I cannot run macros. Thanks Randy "Shah Shailesh" wrote: -------------------------------------------------------------------------------------------------- Posted by Jim Reach. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan set to 1. ----------------------------------------------------------------------------------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Office Menu-2003 for Office-2007) If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Shawrie777" wrote in message ... Yes i know. I saved it in "xlsm" format but the macro will only work if i remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
How do I elminate the password from my password protected excel 2007 file?
-- Randy "Shah Shailesh" wrote: -------------------------------------------------------------------------------------------------- Posted by Jim Reach. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan set to 1. ----------------------------------------------------------------------------------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Office Menu-2003 for Office-2007) If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Shawrie777" wrote in message ... Yes i know. I saved it in "xlsm" format but the macro will only work if i remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros and Passwords
Shah or Jim,
In the registry I can follow the path this far: HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ but after that the files do not seem to be there. There is a file with the data set to 1, should i change it to a zero, or is in suppose to be 1. Any help would be great. "Shah Shailesh" wrote: -------------------------------------------------------------------------------------------------- Posted by Jim Reach. "In Excel 2007, if you password protect your workbooks and they contain macros, there is no way to enable macros." Not "no way". There is a registry entry that turns this security feature off. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\E xcel\Security\ExcelBypassEncryptedMacroScan set to 1. ----------------------------------------------------------------------------------------------------- Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Office Menu-2003 for Office-2007) If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://in.geocities.com/shahshaileshs/menuaddins "Shawrie777" wrote in message ... Yes i know. I saved it in "xlsm" format but the macro will only work if i remove the password "Chip Pearson" wrote: In Excel 2007, there are two different files formats. This is different than 2003 and earlier versions in which there was only one file format. Excel 2007 has "xlsm" files that can contain VBA code and "xslx" files that do not allow VBA code. You must be sure that you are saving as an xslm file format. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Shawrie777" wrote in message ... I'm using office 2007, the message bar says: security warning: macros have been disabled but the options don't allow me to enable it, my macro option is set to allow all but the macro only works if i remove the password "Shawrie777" wrote: When i attached a password to a file with a macro I get a security warning and I can't make the macro work unless i save the file with no password. Does anyone know a way to have both a macro and a password? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macros, Passwords, and XP | Excel Discussion (Misc queries) | |||
| Passwords in macros | Excel Worksheet Functions | |||
| Macros & passwords | Excel Discussion (Misc queries) | |||
| Macros & Passwords | Excel Discussion (Misc queries) | |||
| Macros, Protected Books & Missing Passwords | Excel Worksheet Functions | |||
Linear Mode
