Error calling a procedure not in a module

I am trying to call a procedure that is not located in a module but the procedure is located in sheet3. I am not sure how to call the procedure. I did try moving the procedure code to the module but then it would not work (it does work if I run the code on it's own but just can't call it). I am getting a "sub not defined" error.

I haven't included all the code to this post as it is way too long. I can attach a copy of an example spreadsheet if needed. Thanks.

Change book, sheet & macro names to suit

Please Login or Register  to view this content.