Beginner help! error no return() or halt() function found on macro sheet
 

Im very new and lack much knowledge about what im doing, so please b
kind and very simple.

im attempting to make a form for submittals. I am using a drop dow
menu for company names that these submittals will be sent to. and
drop down menu for the project# these submittals reference. this for
gets printed and attached to whatever im sending, on the second shee
of the workbook im recording key info that I want to save in a log.
have this info sent to a database.

everything was working fine untill

1--I added the drop down menus, is there and end command I nee
somewhere?
2-- inorder to update the existing workbook, I save-as, and changed th
name, i think it kept the link to the existing database, but after th
error message, nothing works...

please help

--
steppin1
-----------------------------------------------------------------------
steppin16's Profile: http://www.excelforum.com/member.php...fo&userid=3583
View this thread: http://www.excelforum.com/showthread.php?threadid=55613

Beginner help! error no return() or halt() function found on macro sheet
 

This is an error associated with XL4 macros. Could be any of a number of
factors.

Lotsa hits on a Google search. Pay special attention to those having the
error when using Template Wizard With Data Tracking.


http://makeashorterlink.com/?T107329C3


Gord Dibben Excel MV


On Tue, 27 Jun 2006 12:31:22 -0500, steppin16
wrote:


Im very new and lack much knowledge about what im doing, so please be
kind and very simple.

im attempting to make a form for submittals. I am using a drop down
menu for company names that these submittals will be sent to. and a
drop down menu for the project# these submittals reference. this form
gets printed and attached to whatever im sending, on the second sheet
of the workbook im recording key info that I want to save in a log. I
have this info sent to a database.

everything was working fine untill

1--I added the drop down menus, is there and end command I need
somewhere?
2-- inorder to update the existing workbook, I save-as, and changed the
name, i think it kept the link to the existing database, but after the
error message, nothing works...

please help!

Gord Dibben MS Excel MVP