I have these following codes on my Work book open event.
Application.EnableEvents = False
[changemonitor] = "No change"
Application.EnableEvents = True
I have my this file saved on the network drive, so we all can use it. my question is, is it going to effect sharing workbook procedure. Like for example if some has it open, and then when I open, it should give me message that, its only read only file, I cannot save any changes.
But today somebody has that alrady open , and later on I opend that as well, but it did not gave me that message about read only, becasue its alrady open by an other user. just woundering that may be that is effecting. Any idea?
Thanks
Application.EnableEvents = False
[changemonitor] = "No change"
Application.EnableEvents = True
I have my this file saved on the network drive, so we all can use it. my question is, is it going to effect sharing workbook procedure. Like for example if some has it open, and then when I open, it should give me message that, its only read only file, I cannot save any changes.
But today somebody has that alrady open , and later on I opend that as well, but it did not gave me that message about read only, becasue its alrady open by an other user. just woundering that may be that is effecting. Any idea?
Thanks