View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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!