PDA

View Full Version : Solved: Multipage



makako
09-07-2006, 07:28 AM
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?

Ken Puls
09-07-2006, 08:54 AM
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 (http://www.excelguru.ca/node/54) that explains using a variable to toggle events. Useform portion is down the bottom. Basically it's that methodology that I'm adapting.

HTH,

makako
09-07-2006, 01:54 PM
thanks for your time, that solves it

Ken Puls
09-07-2006, 02:03 PM
Great! :thumb