Sounds exactly what I want.

Sorry im a newby to this. Could you possibly give me an overview of how I
would do this. :)

Many thanks!


"Gord Dibben" wrote:

And then try to ensure users will not disable macros when opening the workbook.


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 06:06:01 -0700, Gary Brown
wrote:

put code in the worksheet's Worksheet_Deactivate method and in the
ThisWorkbook's Workbook_BeforeSave method so that you can't leave the
worksheet OR save the workbook without putting something in the areas that
you want filled in.