How about a command button labeled "Save As" or whatever. The msgbox could
come up first and, if answered "Yes" then an inputbox could come up to allow
the "SaveAs" specs. The code following would then do the save.
--
Best wishes,

Jim


"kajero" wrote:


I have a specific template that I fill out for certain requests. When I
hit €œSAVE AS€�, is there a way to create a message box that says, "Did
you review the market code" and then provides a check box that says
"no" or "yes". If it you click "yes," then the workbook could be saved,
if you click "no" it would give you the opportunity to review your work,
and do SAVE AS again. I only need this for one specific template; it
only needs to be saved there, not in the personal.xls. A message box
like this would really help cut down on the errors as we have 72
variables and many of them differ only by one character.

I have a basic understanding of VBA code, SQL and macros. If anyone
could help me, I would appreciate it.


Thanks


--
kajero
------------------------------------------------------------------------
kajero's Profile: http://www.excelforum.com/member.php...o&userid=37397
View this thread: http://www.excelforum.com/showthread...hreadid=570776