Rob Bovey's Code Cleaner would also have been my first suggestion (with the
assumption user would use the clearly displayed options as required).

However I vaguely recall having a problem similar to what you describe,
possibly after dragging a Form from one project to another then back again
after renaming (not sure though).

No doubt there's a simple explanation but it might be quicker to rebuild
your workbook. Select all sheets and via a sheet tab copy to a new workbook.
Drag modules from the original workbook into the new workbook.

If that still doesn't work, repeat dragging all except the form module and
re-make a new form.

Regards,
Peter T

wrote in message
oups.com...
Hi all...

I am having a strange issue with Excel v9.0.6926 SP3.

I make changes to a UserForm's design (that I created when using Excel
2003 - just information in case this could be the cause) within my
version of Excel and when I click Save and re-open the UserForm, it
reverts back to its previous state.

I have found a workaround whereby I export the Form first to a file,
then remove the current Form, and then import the saved Form. Then I
save the workbook and this seems to save the changes made to the
design.

I must state that this issue only exists when I change design in some
way, from adding a new control to change the TabIndex property. If I
edit some code and save, the coding is saved.

The same issue occurs on my office computer, but I cannot confirm the
version number right now...

Any ideas?