on workbook open, form optionbutton loses position when unhidden

[Junoon]

Hi ExcelFox,

the optionbuttons were created using the default setting i.e. OptionButton.Placement = xlFloating & not OptionButton.Placement = xlMove. Even if i hardcode OptionButton.Placement = xlFloating, it still moves. Actually, i have tried both alternatives, but still the optionbuttons move from the original location.

See the problem is, if i delete and generate buttons and then hide/unhide buttons, it works well, no issues. But if i hide the buttons, save & close file, and then open it again, then try to unhide it, then the optionbuttons donot stay in their correct position.

please advise.

[Excel Fox]

I did just that! No difference at all!

[Excel Fox]

I am on 2007...