Hi All

I have added a MsgBox message to my system on Workbook_Open to display
a message if the user has opened the system in read-only. The message
just warns them that they cannot make changes. This works fine.

I have now written a report generator which opens the main system in
read-only mode to collect the data. The problem is that my report
generator also gets the read-only message and therefore waits for me
to click "OK".

How can I supress this message from my report generator code yet still
have it pop up for a normal user?

Application.DisplayAlerts = False does not solve the problem as my
message is a MsgBox and not an Excel alert.

Any ideas? Thanks in advance,
Chrisso