Adding Comments After Close & Re-Open

Hi

Yes you've got the right idea.

Create a variable cell called say 'CommentTest' and set it to zero and in your procedures add an introductory line

Please Login or Register  to view this content.

Now in your Workbook Save Event Event add a line

Please Login or Register  to view this content.

Richard Buttrey,

Hi, and thank you for the response. The issue I'm facing is that the user can keep the file open & continue to create new workbooks. I have a cell (let's say, A1, which I've called "Student_Name"). Let's say there's another cell (B1, called "Grade").

If the user types "John Doe" into A1, and "100" into B1 & then clicks "save" the file will rename itself to "John Doe.xlsm"... however, the user can keep the file open & enter "Fred Smith" into cell A1 & "90" into cell B1 & then click "save" & the file will again rename itself to "Fred Smith.xlsm" - the user can do this as many times as he has data for.

However, once he closes out the final workbook, what I want is the ability to capture the NEXT time the file is opened & changed - that way, if someone (either the original user, or a different user) opens the file called "Fred Smith.xlsm" and changes the grade from "90" to "100" - I want a comment to appear stating such.

Thanks,
Rob

P.S. I think I may have answered my own question - I think I need the event to be on "open" and not on "save"... I'm going to try to implement that & will report back whether it works or not.

OK, so I figured it out... here is what I did (in case anyone else can be helped by this):

Please Login or Register  to view this content.

And:

Please Login or Register  to view this content.

And finally:

Please Login or Register  to view this content.

So, thank you for getting me on the right track such that I could modify the code to suit my specific needs!!!

Thanks,
Rob