To by-pass the "RULE", set the security level of Excel to enable the by-pass
of all macro functions.
--
Gary's Student
gsnu200707


"Sean" wrote:

I have some code that will only open a Workbook if a User is listed
within a Named Range. The user is dependent on selecting a dropdown
within the file itself, thus "before the workbook is opened" this
value will be blank, to counter this I have a formula in the Named
Range that says if The User cell is blank, return the applications
username, thus it gets past the situation where its the incorrect user
temporarily, or so I thought, the Workbook has to Open in order to
refresh this formula

Any ideas of how I could get around this, in essense anyone should be
able to open the file, but when the User is selected, the rules kick
in

Thanks