![]() |
renaming a page doesn't stick
This code below will rename the Active Page on my multipage. But it doesn't
stay named. The next time I use the form, it's lost it's name. I've done this similar thing for labels, and their caption will stick, why wn't this? Private Sub cmRename_Click() Me.MultiPage2.SelectedItem.Caption = MyValue End Sub Private Sub cmCloseForm_Click() ActiveWorkbook.Save Unload UserForm End Sub |
renaming a page doesn't stick
Hi,
Run-time changes do not stick. Please, check your label again... say it shows 'my label' at design-time then run your code to show 'hello'. Now, save the book. Close and re-open the book and you'll see that the label setting is back to the design-time caption 'my Label'. When your save a book/project, only Design-time settings are saved. (There might be a few exceptions, I can't think of any right now.) -- Regards, Sébastien <http://www.ondemandanalysis.com <http://www.ready-reports.com "Charlie" wrote: This code below will rename the Active Page on my multipage. But it doesn't stay named. The next time I use the form, it's lost it's name. I've done this similar thing for labels, and their caption will stick, why wn't this? Private Sub cmRename_Click() Me.MultiPage2.SelectedItem.Caption = MyValue End Sub Private Sub cmCloseForm_Click() ActiveWorkbook.Save Unload UserForm End Sub |
All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com