View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
sebastienm sebastienm is offline
external usenet poster
 
Posts: 694
Default 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