Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
FIND function does not return ZERO when text is not found DOUG01A Excel Worksheet Functions 5 August 5th 08 05:56 PM
Halt Rest of Macro after Error €“ Jim Cone review Jenny B. Excel Discussion (Misc queries) 2 January 12th 08 03:11 AM
"No RETURN() or HALT() function found on macro sheet." Will Excel Worksheet Functions 2 January 4th 07 10:10 PM
No RETURN() or HALT() function found on macro sheet [email protected] Excel Discussion (Misc queries) 3 September 26th 06 03:35 PM
search function without error if not found anderssweden Excel Programming 1 June 14th 06 03:38 PM


All times are GMT +1. The time now is 05:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"