How do you have the user name of a person print out when the individual prints out a spreadsheet. This is the same as "user name" in the "user information" field in MS Word.
This seems like it should be easy, but I cannot figure it out!
Thanks,
Robin
Hi, put this code into the ThisWorkbook module
Please Login or Register to view this content.
accidental duplicate post
Thank you for your reply! Unfortunately, I cannot get it to work.
I have opened a new sheet, Alt F11, Selected "This Worksheet", Pasted into Module, Saved, then tried to run the Macro.
I got "Compile error: Expected End Sub"
See attachments. I am new to VBA.
thanks for any suggestions.
Robin
Excel Macro 2.pngexcel macro 1.png
hi,
try to goto vb editor, click on This Workbook (left side), in the right side choose Workbook before print
and copy/paste there the code provided by npamcpp.
hope it helps you!
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
In your original code just change one line.
from:
to:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by rollis13; 05-16-2012 at 05:56 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks