The security setting is dependant on the local machine and one can't
override it as far as i know.
What i tend to do in cases like these - make the wb unusable without
macros enabled, e.g., hid (very hidden) all but 1 ws, pwd protect the
vbe project and then have the thisworkbook_open code unhide the
necessary ws. So, if the user doesn't enable macros - the wb is
useless.


On Apr 27, 4:16*pm, Schatzi wrote:
I am publishing the workbook in a shared file and would like users to
not ahve to always enable macros themselves. The problem is security.
I want several users to be able to access the workbook, but not be
able to save it. I locked up the workbook and disabled the save
buttons (I put code in the "thisworkbook" file in VB. The disabling of
the save function only works when macros are enabled. Thus, the user
would be able to save it before enabling macros and running the
workbook. Once they have it on their personal computer they would be
able to hack into it as they please. Any ideas?