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