Beforeclose problem when file is opened as Read only

Hello,

When my workbook is opened as read only with macro's enabled the VBA gives an error when I wan't to close the workbook?

As you can see the beforeclose saves a copy to a specific location and a backup.

can this be solved by making it skip the code when the workbook is opened in read only mode??

Please Login or Register  to view this content.

SaveCopyAs should be fine, I would think, but the ThisWorkbook.Save will fail. Try:

Please Login or Register  to view this content.