Consulting

Results 1 to 4 of 4

Thread: Solved: Multipage

  1. #1
    VBAX Contributor
    Joined
    Aug 2006
    Posts
    120
    Location

    Solved: Multipage

    Hi, Im working with a multipage and I need to lock one page in certain events so that the user isnt able to choose another until a button is clicked. Currently I have tried disable the multipage but the contents inside are also diabled, I have hidden all the other pages (which works but takes a while for the other 13 pages), and thats it. Is there any simpler way?

  2. #2
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Personally, I'd set up a module level variable that is set to 1 when your button is clicked. Then use the Multipage_Change event to check if the value is 1 (or greater). If it is, allow the user to change pages. If not, send them back to the original page.

    I have an article on my site that explains using a variable to toggle events. Useform portion is down the bottom. Basically it's that methodology that I'm adapting.

    HTH,
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





  3. #3
    VBAX Contributor
    Joined
    Aug 2006
    Posts
    120
    Location
    thanks for your time, that solves it

  4. #4
    Moderator VBAX Guru Ken Puls's Avatar
    Joined
    Aug 2004
    Location
    Nanaimo, BC, Canada
    Posts
    4,001
    Location
    Great!
    Ken Puls, CMA - Microsoft MVP (Excel)
    I hate it when my computer does what I tell it to, and not what I want it to.

    Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar

    This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!

    Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!





Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •