Pete634
05-29-2007, 06:35 PM
Can anyone help me with this?
I've built a workbook with containing a number of userforms , which are accessed via a "Main Menu" userform which automatically loads on opening the workbook. A userform will always show on the screen, and a user can only get back to the main menu.
I've found some good code to disable the cancel button on the forms which I want to use to help achieve the above, but I will need to get back into my workbook at some point for further development. So, I put a commandbutton on the Main Menu titled "Developer" which, when pressed, will prompt for a password. Only when the correct password is entered will the Main Menu close, thereby allowing only me to access the workbook and the VBA code behind it.
Trouble is, I don't know how to code this last bit?
Any takers ?!
PS. I would post the workbook, but I'm still a VBA Newbie and you'll all laugh at my work (pages and pages of If statments!!!):blush
I've built a workbook with containing a number of userforms , which are accessed via a "Main Menu" userform which automatically loads on opening the workbook. A userform will always show on the screen, and a user can only get back to the main menu.
I've found some good code to disable the cancel button on the forms which I want to use to help achieve the above, but I will need to get back into my workbook at some point for further development. So, I put a commandbutton on the Main Menu titled "Developer" which, when pressed, will prompt for a password. Only when the correct password is entered will the Main Menu close, thereby allowing only me to access the workbook and the VBA code behind it.
Trouble is, I don't know how to code this last bit?
Any takers ?!
PS. I would post the workbook, but I'm still a VBA Newbie and you'll all laugh at my work (pages and pages of If statments!!!):blush