View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson[_5_] Jim Thomlinson[_5_] is offline
external usenet poster
 
Posts: 486
Default Undefined function

Try putting it in a standard module, instead of thisworkbook.
--
HTH...

Jim Thomlinson


"q" wrote:

I've place a command button on Sheet1. In the click event I call a user
defined public function which I created in the ThisWorkbook module called
Init. When I click on the command button, I get an error: "Sub or Function
not defined."

It is a public function and there are no spelling errors. Why am I getting
the error?

Thanks.