ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   renaming a page doesn't stick (https://www.excelbanter.com/excel-programming/403250-renaming-page-doesnt-stick.html)

Charlie

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


sebastienm

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