group of worksheets in a workbook

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
Johnnyboy5 formulated on Saturday :
Hi

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

J
Click to expand...

Loop through ActiveWindow.SelectedSheets for a list of sheetnames.
 
Johnnyboy5 formulated on Saturday :




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
Click to expand...

Hi

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

Johnnny
 
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


_________________________
 
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

_________________________
Click to expand...

Wow - thanks - works a treat -

Johnnyboy
 
Back
Top