Hi all,
I have the code below (I appreciate it is not exactly neat or tiday but it does the job) which copies date from one workbook to another as long as the 2nd workbook is not read -only. There are, however, quite a few of us that use it, therefore how would I get the message box to show the windows log on username of the person who currently has the workbook in the read-only state instead of "another user", it will be easier than firing out regular emails to everyone if you can ask the person directly!
Please Login or Register to view this content.
Bookmarks