View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] junk-mail@on-your-bike.co.uk is offline
external usenet poster
 
Posts: 2
Default UserForm does NOT save changes to design (Excel 2000)

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?