Tom,
Where do you put this code? In an autoopen proc?
Is there some way to get this to run when a new copy of a worksheet is
created?

Actually, why is this even necessary? KB article
http://support.microsoft.com/kb/211978/en-us says GroupNames are mutually
exclusive across worksheets. But I'm not finding this to be the case.
ie. Radio buttons with the same GroupName property are acting like one group
even when they are located on different worksheets. It's not supposed to work
that way, but that's what I'm seeing (Excel 2000)



"Tom Ogilvy" wrote:

Dim sh as Worksheet
Dim oleObj as OleObject
for each sh in Worksheets
for each oleObj in sh.OleObjects
if typeof oleObj.Object is MSforms.OptionButton then
oleObj.Object.GroupName = sh.Name
end if
Next
Next


--
Regards,
Tom Ogilvy