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?

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?

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?

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?

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?

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?

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?

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?

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?

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?