userform question

viper · May 24th, 2002, 09:40 PM

Is there a way to disable the "x" on a userform or any code I can use so that a user cannot click on the "x" to close out the userform without inputting the password?

Ivan F Moala · May 24th, 2002, 09:52 PM

Quote:

On 2002-05-24 20:40, viper wrote:
Is there a way to disable the "x" on a userform or any code I can use so that a user cannot click on the "x" to close out the userform without inputting the password?

Yes you can do this Via API,but why not just do it via the Forms QueryClose event.
Look this up in the help file.

viper · May 24th, 2002, 10:30 PM

Thanks Ivan,

worked as needed.

May 24th, 2002, 09:40 PM	#1
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Is there a way to disable the "x" on a userform or any code I can use so that a user cannot click on the "x" to close out the userform without inputting the password? __________________ I appreciate the help from everyone at Mr. Excel. viper

May 24th, 2002, 10:30 PM	#3
viper Board Regular Join Date: Feb 2002 Location: Jefferson City, Missouri Posts: 383	Thanks Ivan, worked as needed. __________________ I appreciate the help from everyone at Mr. Excel. viper

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode