Hello!
I have a spreadsheet that will run a macro to calculate values and then package everything for printing. The code is set to provide a print preview at the end of the macro using: .PrintPreview.
The result is this window pops up:
This works perfectly for me and for the majority of users. However, some users have reported that the macro is skipping the Print Preview stage and sending the file directly to their default printer and printing. I cannot figure out what could be causing this since it does not seem to be directly related to the VBA code. Is there perhaps a user setting on those peoples' computers that could be causing their excel to skip the preview even though the code specifically calls for a preview? Or any other ideas as to what could be causing the issue?
Thanks!
I have a spreadsheet that will run a macro to calculate values and then package everything for printing. The code is set to provide a print preview at the end of the macro using: .PrintPreview.
The result is this window pops up:
This works perfectly for me and for the majority of users. However, some users have reported that the macro is skipping the Print Preview stage and sending the file directly to their default printer and printing. I cannot figure out what could be causing this since it does not seem to be directly related to the VBA code. Is there perhaps a user setting on those peoples' computers that could be causing their excel to skip the preview even though the code specifically calls for a preview? Or any other ideas as to what could be causing the issue?
Thanks!