LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to format userform label at design time? Denis[_4_] Excel Programming 2 July 1st 06 10:01 PM
where can i get some design examples spreadsheets in excel 2000 db310756 Excel Discussion (Misc queries) 1 May 9th 06 12:41 AM
Control Toolbox does not appear when trying to design a Userform! [email protected] Excel Programming 7 January 23rd 06 01:40 PM
Nudging controls in UserForm Design Mode Rick Brown Excel Programming 1 September 21st 04 11:47 PM
load userform from other VBProject (Excel 2000) Keith Willshaw Excel Programming 1 July 28th 03 04:12 PM


All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"