L
Lucky
Hi,
In Excel 2003 and older, I had a macro running that was selecting
multiple sheets and was presenting the result under printpreview mode
to the user. Exiting this mode (after a print or a close selection by
the user), that same macro was un-selecting the sheets and replacing
the user in the same situation then before executing the macro.
In Excel 2007, it works but no Excel buttons are visible to the user
so that he cannot print, he can only push "Escape" key to exit that
mode.
I tried that code :
If Application.Version < 12 Then
ActiveWindow.SelectedSheets.PrintPreview
Else
SendKeys "^{F2}"
End If
It works, but if I have the simple code following (to replace the
file) :
Sheets(Feuille2).Select
Then I preview only the sheet "Feuille2"
Does anybody have a solution ?
Thank you
In Excel 2003 and older, I had a macro running that was selecting
multiple sheets and was presenting the result under printpreview mode
to the user. Exiting this mode (after a print or a close selection by
the user), that same macro was un-selecting the sheets and replacing
the user in the same situation then before executing the macro.
In Excel 2007, it works but no Excel buttons are visible to the user
so that he cannot print, he can only push "Escape" key to exit that
mode.
I tried that code :
If Application.Version < 12 Then
ActiveWindow.SelectedSheets.PrintPreview
Else
SendKeys "^{F2}"
End If
It works, but if I have the simple code following (to replace the
file) :
Sheets(Feuille2).Select
Then I preview only the sheet "Feuille2"
Does anybody have a solution ?
Thank you