Best Practices - Workbook security & macros

[news.microsoft.com]

I have developed an Excel 2007 Workbook that uses vba quite extensively for
allowing privileges, determining the user's Excel version, hiding,
protecting, etc. In the privileges area, external users have the "PLY"
commandbar shutdown so the cannot browse through the internal sheets. They
also have different ribbon tabs, groups and buttons.

However, the Workbook template will be placed on the Internet for download
by potential partners (external users) as well as hackers no doubt. If it is
placed in a non-trusted location and run the Microsoft "enable macros" comes
up and, if the user doesn't enable macros the keyboard commands are
available which allows full control over the contents of the Workbook.

What are the ways and means to protect the content until such time that
macros have been enabled? I will certainly place a password on the VBA
project but would making all sheets xlVeryHidden do much?

I thank you for your help and advice on this. I am sure there are others who
face this problem.

Sincerely,

rick

 

[Chip Pearson]

You'll probably find the following pages useful:
http://www.cpearson.com/Excel/EnableMacros.aspx
http://www.cpearson.com/Excel/EnableMacros2.aspx


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

 

[news.microsoft.com]

Thank you very much Chip. As usual, your advice is always right on point. I
am trying out the first link's code.

Regards,
Rick Street

You'll probably find the following pages useful:
http://www.cpearson.com/Excel/EnableMacros.aspx
http://www.cpearson.com/Excel/EnableMacros2.aspx


Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]

I have developed an Excel 2007 Workbook that uses vba quite extensively
for
allowing privileges, determining the user's Excel version, hiding,
protecting, etc. In the privileges area, external users have the "PLY"
commandbar shutdown so the cannot browse through the internal sheets. They
also have different ribbon tabs, groups and buttons.

However, the Workbook template will be placed on the Internet for download
by potential partners (external users) as well as hackers no doubt. If it
is
placed in a non-trusted location and run the Microsoft "enable macros"
comes
up and, if the user doesn't enable macros the keyboard commands are
available which allows full control over the contents of the Workbook.

What are the ways and means to protect the content until such time that
macros have been enabled? I will certainly place a password on the VBA
project but would making all sheets xlVeryHidden do much?

I thank you for your help and advice on this. I am sure there are others
who
face this problem.

Sincerely,

rick