Multipage Userform Tab Lock
Hello,
Does anyone know how to prevent a user from navigating a multipage form by using the tabs at the top of the screen? In other words, I would like the user to see the pages, but require them to navigate forward and back using coded command buttons that I created, instead of selecting the tabs at the top. This is because I use a validation to confirm all data is entered before the user can advance a page using the "Next" button.
Thanks
surge
Hello gsurge,
Change the Style property of the MultiPage to fmTabStylesNone. This will remove the tabs forcing the user to navigate with your buttons.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you for that tip. Is there any way of keeping them visible but just locking them from the user?
Hello gsurge,
There is no way I am aware of.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks