Conflict between VBA and worksheet functions?

cogman

New Member

Join Date: Jan 2007

Posts: 1

30th Jan 2007

To avoid including a reference to the atpvbaen.xls file, I created a public function called Workday() in a module for a spreadsheet. I have since deleted this function from the spreadsheet and it seems to be causing a problem with the WORKDAY() function in the worksheets. Formulas that have already been written work OK, but if I write a new one including this function, I get the #NAME? error messgae. I have tried restarting excel and removing and reinstalling the Analysis ToolPak AddIn but it still doesn't work.

Has anyone had this problem before?

Thanks

John

« Find closest date or matching | View Modules »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Optional Variables in Functions (REPLACE and other 'Worksheet' functions)	Evi	Microsoft Access Queries	2	6th May 2008 09:59 PM
Public Functions As Worksheet Available Functions	=?Utf-8?B?U3RldmUgS2luZw==?=	Microsoft Excel Programming	3	12th Feb 2005 07:55 PM
Combo Box/Worksheet Protection Conflict	=?Utf-8?B?UGhpbCBIYWdlbWFu?=	Microsoft Excel Programming	4	12th May 2004 07:26 PM
Name Conflict Copying Worksheet	Mike Rosenberg	Microsoft Excel Programming	0	25th Mar 2004 10:09 PM
Conflict Of Macros In Worksheet	MathewPBennett	Microsoft Excel Misc	3	22nd Dec 2003 11:30 PM