I need help with a form to be used by many people. There are several
fields that I would like to have populated with text, date, phone
number, etc. before the user can save the form. Is there any way to
force someone to enter a field prior to saving the worksheet?


--
mhart210
------------------------------------------------------------------------
mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413
View this thread: http://www.excelforum.com/showthread...hreadid=556608

You can have Before_Save code in ThisWorkbook module that won't let the user
save/close the workbook.

The efficacy of this hinges upon the user enabling macros when opening the
workbook.

Of course, you have to make the workbook unusable if users decide to disable
macros.

That is another set of code.


Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 13:32:01 -0500, mhart210
wrote:


I need help with a form to be used by many people. There are several
fields that I would like to have populated with text, date, phone
number, etc. before the user can save the form. Is there any way to
force someone to enter a field prior to saving the worksheet?

Thank you for the tip, of course you have peaked my interest in the
disabling of the worksheet. Would I use deactivate for this?


--
mhart210
------------------------------------------------------------------------
mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413
View this thread: http://www.excelforum.com/showthread...hreadid=556608

You add a sheet to the workbook with a message "If you have disabled macros,
this workbook is useless" or similarly frightening.

In Before_Close sub you xlveryhidden all the sheets but that one.

If users open the workbook with macros disabled, this is all they will see.

If macros are enabled, your Workbook_Open code will unhide the other sheets and
hide the message sheet and your Before_Save code will be enabled also.


Gord



On Thu, 29 Jun 2006 07:06:15 -0500, mhart210
wrote:


Thank you for the tip, of course you have peaked my interest in the
disabling of the worksheet. Would I use deactivate for this?

Thanks. Very much apperciated!!!!


--
mhart210
------------------------------------------------------------------------
mhart210's Profile: http://www.excelforum.com/member.php...o&userid=26413
View this thread: http://www.excelforum.com/showthread...hreadid=556608