Conflict between VBA and worksheet functions?

C

cogman

Joined
Jan 30, 2007
Messages
1
Reaction score
0
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
 
Back
Top