The Tamer
10-20-2004, 02:08 PM
Hi, I need vba to do the following when this workbook is opened:
1) check whether the book opened read only
2) (if it DID open read-only) compare the ID of the other person who has it open from a list that i will put in a sheet called "I.D. list", The names will be in column B (rows 1-30) and their IDs in column A
2a) if it finds an I.d. match in the list, a message box will say the name of the person
2b) if not it will say it can't find a match.
3) (if it did NOT open read only) it will tell the user to do their work as quickly as possible, then to get out!
Ideally, I would like it to substitute the read-only option box for the above, but am i correct to assume that, until a person actually elects to open the book, no macros will be looked at anyway?
I would appreciate help on this as it is a big problem in work, and it?s a report that I'm revamping and will have to maintain.
Thanks
1) check whether the book opened read only
2) (if it DID open read-only) compare the ID of the other person who has it open from a list that i will put in a sheet called "I.D. list", The names will be in column B (rows 1-30) and their IDs in column A
2a) if it finds an I.d. match in the list, a message box will say the name of the person
2b) if not it will say it can't find a match.
3) (if it did NOT open read only) it will tell the user to do their work as quickly as possible, then to get out!
Ideally, I would like it to substitute the read-only option box for the above, but am i correct to assume that, until a person actually elects to open the book, no macros will be looked at anyway?
I would appreciate help on this as it is a big problem in work, and it?s a report that I'm revamping and will have to maintain.
Thanks