Selecting / UnSelecting sheets

[shuvro_basu]

Hi,

I have used this forum before to get help on my excel issues. Now I
have come up with a situation that I cant get around (due to my limited
knowledge).

I will appreciate your help if someone can point out a way to
select/unselect multiple sheets from a workbook using a macro.. a
generic one that i can use from a custom toolbar..

thanx in advance.

Cheers !!!
Shuvro

 

[Dave Peterson]

How would that generic macro know which sheets to select (and which to skip)?

Worksheets.select
or
sheets.select

would get all of the worksheets (or all of the sheets), though.