Hi Col,

You may want to look into signing your VBA-enabled workbooks:

http://msdn.microsoft.com/library/de.../odc_dsvba.asp

This will allow users to "trust" your certificate _and_ leave their macro
security settings on High.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

colofnature wrote:
My company (the one I work for, I don't own it or anything) is about
to upgrade - finally - from WinNT to XP. They're also changing company
protocol to include a rule that the secuirity level in end user
products (i.e, MS Office) should be set to High.

My problem is that I have several models (spreadsheets, used as
front-end to Access databases) which require lower security settings.
I've trained the users in how to reduce the security settings, but I
can't trust them enough to reset it after they're finished (it being
my responsibility to ensure that they do). My question then is this:
Can I detect, at application level, when someone opens a file whose
name is in a (write protected) text file, and reduce the macro
security level accordingly, and raise it again when said file is
closed or deactivated.

Any ideas gratefully recieved...
Col