ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Bypass macros in Read only (https://www.excelbanter.com/excel-programming/283751-bypass-macros-read-only.html)

Lawlera

Bypass macros in Read only
 
Is there some code that will bypass/disable certain macros if the file is opened with read only status

Thanks in anticipation,

Harald Staff

Bypass macros in Read only
 
I don't think so, but you could put this in the beginning of the macros in
question:

If ThisWorkbook.ReadOnly Then Exit Sub

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Lawlera" skrev i melding
...
Is there some code that will bypass/disable certain macros if the file is

opened with read only status?

Thanks in anticipation,




Lawlera

Bypass macros in Read only
 
Thanks Harald - works a treat!


All times are GMT +1. The time now is 04:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com