Hi All,

I`m looking for code to prevent a user from saving an excel workbook, i
barely remember playing with code at the beginning of this year in class
that displayed a message saying "Sorry, this workbook cannot be saved"
if the user attempted to save the file.

I`m working on a college project and have a very simple piece of code
that handles "registration". So if a user presses the button named
"register" they are taken to a form to insert the registration code. I
managed to get the code to enable and disable the Register button if
the code entered is correct, store it in a sheet and check it on close
and startup of the workbook.

Now the fun part, if the registration number aint been entered, or is
invalid, then the user isn't allowed to save anything they enter,
muhahahaha.

If i rememebr correctly, it's very simple to do, something to do with
the message boxes that displays information, OK/CANCEL, etc. but i
can't for the life of me rememebr the code.

I`m gonna dig out my old notes anyway. I`d be gratefull for any
assistance :)


~LocVez


--
LocVez
------------------------------------------------------------------------
LocVez's Profile: http://www.excelforum.com/member.php...o&userid=24021
View this thread: http://www.excelforum.com/showthread...hreadid=376379