Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to unselect? | Excel Programming | |||
Unselect range | Excel Programming | |||
Unselect Option Box | Excel Discussion (Misc queries) | |||
Unselect a Cell?????? | Excel Programming | |||
Unselect Filtre .... | Excel Programming |