ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2003 to 2007 , ActiveWorkbook.ReadOnly (https://www.excelbanter.com/excel-programming/422675-2003-2007-activeworkbook-readonly.html)

EXCELMACROS

2003 to 2007 , ActiveWorkbook.ReadOnly
 
hi, I have the below code that used to work fine on 2003, now on 2007 and I'm
getting false all the time regarless if the file is read-only or not, does
anyone knows how to translate to 2007 the below?


If ActiveWorkbook.ReadOnly = True Then
MsgBox ("You are in Read-Only, please re-open...")
ActiveWindow.Close
Else
....

Thank you in advance
--
Thank you...


All times are GMT +1. The time now is 02:16 AM.

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