I have a userform which acts as an interface for database information contained in Sheet 1.
On the userform I have a Print button which copies the currently displayed record to a Print Template in Sheet 3 and brings up the standard Print Preview screen
I want the user to be able to print off the sheet and then return to the userform.
Since the user form is open the Excel Print Preview buttons are disabled. How can I enable the options on Print Preview to work and allow printing and then return control back to the user form?
Any help would be greatly appreciated. t.
On the userform I have a Print button which copies the currently displayed record to a Print Template in Sheet 3 and brings up the standard Print Preview screen
I want the user to be able to print off the sheet and then return to the userform.
Since the user form is open the Excel Print Preview buttons are disabled. How can I enable the options on Print Preview to work and allow printing and then return control back to the user form?
Any help would be greatly appreciated. t.