group of worksheets in a workbook
 

Hi

how can I view (to check) which sheets have been included in a group ?

J

group of worksheets in a workbook
 

Johnnyboy5 formulated on Saturday :
Hi

how can I view (to check) which sheets have been included in a group ?

J

Loop through ActiveWindow.SelectedSheets for a list of sheetnames.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

group of worksheets in a workbook
 

On 25 Sep, 23:50, GS wrote:
Johnnyboy5 formulated on Saturday :

Hi

how can I view (to check) which sheets have been included in a group ?

J

Loop through ActiveWindow.SelectedSheets for a list of sheetnames.

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Hi

sorry not quite sure how to do that - is it a macro ?

Johnnny

group of worksheets in a workbook
 

Hello !

You could use "ActiveWindow.SelectedSheets" in a macro to display the name
of the selected sheets.
In a VBA module paste the following code:

Public Sub Show_Selected_Sheets()
Dim Sh As Object, ShList As String

For Each Sh In ActiveWindow.SelectedSheets
ShList = ShList & Sh.Name & vbCrLf
Next Sh
MsgBox ShList

End Sub


_________________________

Hi

sorry not quite sure how to do that - is it a macro ?

Johnnny

group of worksheets in a workbook
 

On 26 Sep, 15:18, "Charabeuh" wrote:
Hello !

You could use "ActiveWindow.SelectedSheets" in a macro to display the name
of the selected sheets.
In a VBA module paste the following code:

Public Sub Show_Selected_Sheets()
Dim Sh As Object, ShList As String

For Each Sh In ActiveWindow.SelectedSheets
* * ShList = ShList & Sh.Name & vbCrLf
Next Sh
MsgBox ShList

End Sub

_________________________





Hi

sorry not quite sure how to do that - is it a macro ?

Johnnny

Wow - thanks - works a treat -

Johnnyboy