UserForm change function of close (X) button

[mkachwee]

Hey guys I want to change the function of a password userform to close a workbook, I've tried the following to no avail:

Please Login or Register  to view this content.

I don't want it to just close the userform as I've read in various articles, I need it to close the workbook - or alternatively have it disabled!

Please help

Thanks

[mkachwee]

Found a nifty solution, had a cmdCancel button which closes the userform if clicked

All I had to do was call the cmdCancel_Click routine when the X button is clicked:

Please Login or Register  to view this content.