View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GB GB is offline
external usenet poster
 
Posts: 230
Default multi page object from excel vba toolkit

I don't know the function name/haven't ever been able to create a tabbed form
like you are describing, but there should be an OnShow or Show subroutine,
and there should be some way to designate the "active" tab/sheet/window,
whatever it is called. So in the OnShow routine, if you make the first "tab"
active, it will do that on reentry each time. Perhaps you may want to also
implement a user option to turn that feature on and off if the sheets can be
used in any order.

Sorry, can't help more.

"christopher ward" wrote:

quick question - i have a system that uses a multipage object to display a
number of tabs when it is called - it is made up of six tabs - when you call
this form how do you make it show the first tab in the list every time as at
the moment it appears to remember what the user was last on and displays that
tab - simple i know but only if you know the answer

thanks in advance
--
C Ward