Christiaan
Board Regular
- Joined
- Nov 5, 2012
- Messages
- 81
Hello every one...
I have a macro that checks the Excel Version/ Build in the 'workbook.open' statement. If the version/ build <> 16.14332, the file should open as 'Read only'.
Currently I am just running a macro that is locking every single sheet/ cell to avoid changes being made (some functions are used that aren't available in previous versions, like the =UNIQUE, =MINIFS and =MAXIFS, and I don't want to get any incompatibility errors...
I cannot use the workbooks.open, since the file is already open. Is there a way to change the 'read only' attribute afterwards?
Any suggestions are most welcome.
Chris
I have a macro that checks the Excel Version/ Build in the 'workbook.open' statement. If the version/ build <> 16.14332, the file should open as 'Read only'.
Currently I am just running a macro that is locking every single sheet/ cell to avoid changes being made (some functions are used that aren't available in previous versions, like the =UNIQUE, =MINIFS and =MAXIFS, and I don't want to get any incompatibility errors...
I cannot use the workbooks.open, since the file is already open. Is there a way to change the 'read only' attribute afterwards?
Any suggestions are most welcome.
Chris
