Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart page renaming is not sticking | Charts and Charting in Excel | |||
Need help getting pictures to stick! | Excel Discussion (Misc queries) | |||
Row Stick | Excel Discussion (Misc queries) | |||
Avoid renaming page fields | Excel Discussion (Misc queries) | |||
Format won't stick | Excel Discussion (Misc queries) |