On 13 Apr, 09:08, "Bob Phillips" wrote:
I would clean up the project. Rob Bovey has a utility to do this, called
Code Cleaner. You can get it atwww.appspro.com

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

wrote in message

oups.com...



Hi all...

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

I make changes to aUserForm'sdesign (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 theUserForm, 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?- Hide quoted text -

- Show quoted text -

I don't like that tool, first because it didn't work, but second
because it removes the layout of my code and all the comments - why
would anyone feel the need to write a tool that does that?!

I tried it all the same, and it still fails to resolve the problem,
still can't make changes to the UserForm design and save as normal :o(

Cheers,

Phil