Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Multiple Selected Worksheets
Hi,
I'm trying to create a macro that will only affect the worksheets that are currently selected (when a user uses ctrl+click on multiple worksheet tabs). How do I identify which worksheets are selected in VBA? Thank you very much, -David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Multiple Selected Worksheets
This code shows a message box for each selected worksheet in the workbook:
For Each sh In Workbooks("BOOK2.XLS").Windows(1).SelectedSheets MsgBox sh.Name Next HTH -- Michael J. Malinsky Pittsburgh, PA "I am a bear of very little brain, and long words bother me." -- AA Milne, Winnie the Pooh "DavidMatthews" wrote in message ... Hi, I'm trying to create a macro that will only affect the worksheets that are currently selected (when a user uses ctrl+click on multiple worksheet tabs). How do I identify which worksheets are selected in VBA? Thank you very much, -David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying Multiple Selected Worksheets
Hi David
You can loop through them like this Sub test() Dim sh As Worksheet For Each sh In ActiveWindow.SelectedSheets MsgBox sh.Name Next End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "DavidMatthews" wrote in message ... Hi, I'm trying to create a macro that will only affect the worksheets that are currently selected (when a user uses ctrl+click on multiple worksheet tabs). How do I identify which worksheets are selected in VBA? Thank you very much, -David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print selected worksheets in multiple workbooks? | Excel Discussion (Misc queries) | |||
locking selected cells on multiple worksheets | Excel Worksheet Functions | |||
Print selected pages from multiple worksheets | Excel Discussion (Misc queries) | |||
Trouble identifying selected records | Excel Discussion (Misc queries) | |||
Identifying a Selected Range in a Macro | Excel Discussion (Misc queries) |