Auto_Open macro: read-only after expiry

[Dirty Laundry]

Hello - I am looking for assistance with my Auto_Open macro. Currently it forces the workbook closed after a designated expiration date. I'm trying to alter it so that users have read-only access to the workbook after it expires, rather than forcing it closed. Any suggestions would be greatly appreciated. Thanks! - DL

Please Login or Register  to view this content.

[Firefly2012]

Hi

Instead of ActiveWorkbook.Close you could use:

Please Login or Register  to view this content.

To change file access to Read Only. I have to say though that this is very easy to avoid eg by disabling macros on open.