Excel VBA - Problem with Closing Print Preview

T

tedkima27

Joined
Nov 1, 2022
Messages
1
Reaction score
0
Hi Folks,

I am creating an entry form for data in Excel VBA. On one particular form(UserForm5) I have a button that can shows me print preview of a selected range - A1:31 of a particular worksheet - InputSheet. Print preview works fine but every time I click 'close Print Preview' there is an error "Code execution has been interrupted".

Please help me correct this:

Private Sub CommandButton5_Click()
Me.Hide

With Sheets("InputSheet")
Range("A1:I32").PrintPreview
End With

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help in printing vba code 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Print with sevral different print area's 2
Closing Print Preview in Excel Macro 1
Print Preview 12
Resuming code after closing a print preview 2
Print preview from macro problem 2
Print problems w/ charts excel 2003/2007 3

Top