View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Amber_D_Laws[_43_] Amber_D_Laws[_43_] is offline
external usenet poster
 
Posts: 1
Default User Forms - getting them to talk to Excel


Thanks Jakey!

I am still working through the literature that Tom referred me to, an
I have just come across some details on MultiPages. I am glad yo
mentioned them; because other wise I don't know that I would hav
considered them. I like the idea about changing the tab style. Th
whole point of this is to keep my users from being able to change wha
they should not be allowed to change.

Maybe you can give me a little help with something along these lines.
Do you know how to add a status bar of some sort so they can see ho
close to completion they are?
I haven't found anything relating to this so far. I was thinking o
something like sequentially called images, but I am sure there is a
easier way.
Any ideas?


Regards,
Amber:)


JakeyC Wrote:
Design your MultiPage with tabs first so that you can easily switch
between pages. Then, when you are ready to give it to your user
change
the Style propery of the MultiPage to '2 - fmTabStyleNone' which
removes the tabs. Make sure of course that you provide a button for
them to select the next page


--
Amber_D_Law
-----------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...fo&userid=3001
View this thread: http://www.excelforum.com/showthread.php?threadid=50587