Thread: UserForm
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Lasborough Lasborough is offline
external usenet poster
 
Posts: 1
Default UserForm

Try to hide it using "yourform.hide" before the print preview followed by
"yourform.show" when the print preview has completed.

"Steve" wrote:

Hello,

I have a UserForm on a worksheet that I want to go away when I click the
Print Preview button, but reappear in the same position that is was before
the PP button was clicked.

Any help?

Thanks,