Hello,

I was wondering if it was possible to deselect a single sheet in a
workbook.

My code will receive a workbook with all sheets selected. There are
dozens to hundreds of sheets. I want to just unselect a single
sheet. Is there a quick way to do this.

For example, to select all sheets you can say: workbook.sheets.select

This doesnt work, but is there something like workbook.sheets
(3).deselect

Any help would be great.

Thanks

Say you receive a wb with sheets 1 thru 3 selected but you do not wan sheet
2 to be selected.

Sheets(Array("Sheet1", "Sheet3")).Select

Now sheet2 has been deselected. You can do the same thing manually by
holding Ctrl and clicking the sheet2 tab.



"Scott" <(E-Mail Removed)> wrote in message
news:eec0ca37-2d49-49e9-a150-(E-Mail Removed)...
> Hello,
>
> I was wondering if it was possible to deselect a single sheet in a
> workbook.
>
> My code will receive a workbook with all sheets selected. There are
> dozens to hundreds of sheets. I want to just unselect a single
> sheet. Is there a quick way to do this.
>
> For example, to select all sheets you can say: workbook.sheets.select
>
> This doesnt work, but is there something like workbook.sheets
> (3).deselect
>
> Any help would be great.
>
> Thanks