Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a standard way to detect whether more than one sheet is selected in
a workbook? There doesn't seem to be a Worksheets(x).Selected property, which would allow me to flip through the workbook and see whether a group of sheets is selected rather than a single one. What I'm doing now is this: If Right(Application.Caption, 7) = "[Group]" Then which is kludgy and may be dangerous. There must be a better way to do this, but I can't seem to find it. -Tim Aurthur |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn off [Group] mode? | Excel Discussion (Misc queries) | |||
Ability to Group and Ungroup while in Protection Mode | Excel Discussion (Misc queries) | |||
Tab Colors in Group Mode | New Users to Excel | |||
detect ctrl-c was pressed (in copy mode) from vba? | Excel Discussion (Misc queries) | |||
Page setup whilst in Group mode | Excel Discussion (Misc queries) |