CODEWITHSUNDEEP
vbaexcel
Tonemas
Tonemas

Reputation: 1

Change from read-only to read-write does not trigger workbook_open in xlsm

When I try to open excel file which is opened by other user on server, excel offer me two options:

1) open excel file in read-only mode

2) open excel file in read-olny mode and notify me once the other user leave the excel file for writing

If I choose the second option, once the other user leave the excel file, I get message in my excel and open the excel file in read-write mode. If this excel file contains auto_open (or workbook_open) subroutine, it runs only during opening excel file, not again when changing access from read-only to read-write mode.

This is valid in case of xlsm file. In case of old xls file, the auto_open (workbook_open) works both during opening file, as well as during changing the mode from read-only to read-write.

Is there any way to trigger any other subroutine during change from read-only to read-write mode in xlsm file? If not, is there any way to block option "notify" at the warning message about read-only excel file?

warning message same as here

Upvotes: 0

Views: 1088

Answers (1)

user1759942
user1759942

Reputation: 1350

I would have to say no you cant block the "Notify me" option, but what you could do is use a global variable and evaluate that variable in the load function to say if its false(hasnt run) then do whatever stuff, and if its true (meaning its already been run) then not to do whatever stuff

Upvotes: 0

Related Questions