erutherford
Active Member
- Joined
- Dec 19, 2016
- Messages
- 449
This has happened before because I didn't "unload a userform during the execution of the code. When that doesn't appear to be the answer this time. Has to be something pretty simple, just not seeing it. It doesn't matter where I unload the forms, excel locks up at the printpreview. Thanks for reading!
VBA Code:
<
Sheets("Entries").Range("J:J").EntireColumn.Hidden = True
Sheets("Entries").Range("K:K").EntireColumn.Hidden = False
Sheets("Entries").Range("A2:I52", "K2:K52").PrintPreview
Sheets("Entries").Range("J:J").EntireColumn.Hidden = False
Sheets("Entries").Range("K:K").EntireColumn.Hidden = True
Sheets("Entries").Range("L:L").EntireColumn.Hidden = True
'Unload UserForm11
'Unload UserForm12