Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting a criteria range over two sheets? | Excel Discussion (Misc queries) | |||
Selecting sheets - II | Excel Discussion (Misc queries) | |||
Selecting sheets | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Multiple sheets selected | Excel Discussion (Misc queries) |