Can I get the macro to automatically select NO?

[Dibbley247]

Hi
I have the below macro to let only certain users modify a workbook, and the rest read-only.
However, there are several computers within the business with a standard login called "Boxroom" which, would shutdown the workbook if this user has opened it.
But when this user has opened it, it gives the warnings etc, and the last message says: "Do you want to save the changes to........" and gives the options, YES,NO,CANCEL.
Can I get this to automatically select NO? Because if they select Cancel, it will stay open as read only.

Please Login or Register  to view this content.

Many Thanks

[Olly]

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.