How to return a list of all selected Sheets in a Workbook
 

I seem to be unable to return a list of all sheets in a Workbook that are
currently selected by the user. Basically I want to return the Array in

Worksheets(array("x",'y","z")).select

and I 'm having trouble finding a way to return the collection of selected
Worksheet once the are selected by the user.
Any help would be appreciated,

Felix

How to return a list of all selected Sheets in a Workbook
 

The selected sheets are part of the activewindow. So something like this...

ActiveWindow.SelectedSheets.PrintPreview

--
HTH...

Jim Thomlinson


"Felix" wrote:

I seem to be unable to return a list of all sheets in a Workbook that are
currently selected by the user. Basically I want to return the Array in

Worksheets(array("x",'y","z")).select

and I 'm having trouble finding a way to return the collection of selected
Worksheet once the are selected by the user.
Any help would be appreciated,

Felix

How to return a list of all selected Sheets in a Workbook
 

for each sh in ActiveWindow.Selectedsheets
msgbox sh.name
Next

--
Regards,
Tom Ogilvy












































"Felix" wrote:

I seem to be unable to return a list of all sheets in a Workbook that are
currently selected by the user. Basically I want to return the Array in

Worksheets(array("x",'y","z")).select

and I 'm having trouble finding a way to return the collection of selected
Worksheet once the are selected by the user.
Any help would be appreciated,

Felix

How to return a list of all selected Sheets in a Workbook
 

Thank you, worked like a charm

"Tom Ogilvy" wrote:

for each sh in ActiveWindow.Selectedsheets
msgbox sh.name
Next

--
Regards,
Tom Ogilvy












































"Felix" wrote:

I seem to be unable to return a list of all sheets in a Workbook that are
currently selected by the user. Basically I want to return the Array in

Worksheets(array("x",'y","z")).select

and I 'm having trouble finding a way to return the collection of selected
Worksheet once the are selected by the user.
Any help would be appreciated,

Felix