if ActiveWindow.SelectedSheets.count 1 then
msgbox "In group mode"
End if

--
Regards,
Tom Ogilvy


"mailman" wrote in message
...
I am trying it the way you've suggested and it open the vbe window instead
of file open one. sorry
--
XP home , Office 97

any or all responses are gratefully accepted and thank you for your time



"R-N" wrote:

How can I detect if the user is in Group Mode when a macro starts?

I have a macro that needs to warn the user if they are in group mode
before it runs its main actions. I can't find a mechanism like...
If Selection.Sheets.Count 1 or For Each aSheet In Wb.Sheets, If
aSheet.Selected = True etc. etc.

I have a fix that writes an unlikely entry and then looks through the
sheets to see if the unlikely entry has appeared on other sheets but there
must be a better way than this!

Any ideas much appreciated.

Rog