now trying to unselect a sheet
 

Thanks for the great code everyone on my printing problem. Works great!

Now, I have would like to make an addition to the code that
unselects/deactivates the sheets that were printed vis the command "Printout"

I see there is a deactivate command, but I am getting an error trying to use
it. So, how do I deactivate all but the 1st sheet when multiple sheets are
selected?

Thanks!

now trying to unselect a sheet
 

Sub gsnu()
Sheets(1).Select
End Sub

--
Gary''s Student


"Eric" wrote:

Thanks for the great code everyone on my printing problem. Works great!

Now, I have would like to make an addition to the code that
unselects/deactivates the sheets that were printed vis the command "Printout"

I see there is a deactivate command, but I am getting an error trying to use
it. So, how do I deactivate all but the 1st sheet when multiple sheets are
selected?

Thanks!