Print preview from macro problem
 

I'm using a command button in a user form to launch print preview. I've done
this with other workbooks and it's been fine. With this particular workbook
it's causing excel to freeze with only remedy close and reopen. What's
puzzling is I can launch print preview using the normal method from the
spreadsheet and it works fine. Ideas?

Print preview from macro problem
 

Post the relevant code for the button so a meaningful answer can be made.

"Tim G" wrote:

I'm using a command button in a user form to launch print preview. I've done
this with other workbooks and it's been fine. With this particular workbook
it's causing excel to freeze with only remedy close and reopen. What's
puzzling is I can launch print preview using the normal method from the
spreadsheet and it works fine. Ideas?

Print preview from macro problem
 

Also, include any error messages that you receive.

"Tim G" wrote:

I'm using a command button in a user form to launch print preview. I've done
this with other workbooks and it's been fine. With this particular workbook
it's causing excel to freeze with only remedy close and reopen. What's
puzzling is I can launch print preview using the normal method from the
spreadsheet and it works fine. Ideas?