I have a user form that is being printed using .PrintForm.
Is there any way of having the filename in the header or footer of print out?
Thanks
Printable View
I have a user form that is being printed using .PrintForm.
Is there any way of having the filename in the header or footer of print out?
Thanks
Not using PrintForm. Try popping the form name into the Forms Caption just before doing the PrintForm, and then resetting the caption to its original state immediately after doing the PrintForm.
When I print the user form (without using the instructions above) the current caption is not being printed.
Do I need to specify some sort of range on the user form that I want to print?
Anyone any ideas on this?
Still haven't worked out how to do it.
Cheers