Selecting / UnSelecting sheets
 

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

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.

shuvro_basu wrote:

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

--
shuvro_basu

--

Dave Peterson