PASSWORD PROTECT BEFORECLOSE

Giganews Newsgroups
Subject: PASSWORD PROTECT BEFORECLOSE
Posted by:  KandK
Date: Sun, 7 May 2006

Tristan was kind enough to enlighten me into using Visual Basic Editor to
have a message box asking Are you sure you want to close? when someone tries
to close a workbook. However it would be great if I could password protect
the closing of a workbook. This is the first time I have used Visual Basic
Editor so with my very limited experience and Microsoft Excel Help I could
not work out a way. So if anyone has any suggestions or could even tell me it
is not possible it would be greatly appreciated. Many thanks.

Replies