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


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=571978