Calling subroutines

I have a problem that from what I've read should be easy enough to do, but it is driving me mad.

I have an Excel2007 workbook with VBA subroutine which is attached to one of the worksheets. I have placed it there because the worksheet has to be present for the code to work correctly.

This works fine, but I would also like to be able to call it from another worksheet within the same workbook. From what I've read most people seem to say it is simply a matter of calling the subroutine :

Call InsertJournal(2)

Trying to run this code, however, gives me a compile error, sub or function not defined.

Also, is it possible to check the existence of a worksheet with the name "Journals" beforehand to avoid errors?

Thanks in advance

Kevlaw

Putting the code into a module rather than worksheet 'code' solves the problem, but how do I check for the existence of the worksheet before running?

Hi, Have you created your sub from the VBwindow, Toolbar, "Insert", "Module" , or not???
It won't run from Private code module.
Mick

Hi, This should do:-

Please Login or Register  to view this content.

Regards Mick

Thanks both,

I've actually moved the code from the 'code' associated with the worksheet, and into a module attached to the same workbook.

This now works fine.

As the worksheet it affects is needed in all such workbooks there shouldn't be a problem, but is there a way to check the existence of a sheet with a particular name, as I expect colleagues of mine will eventually use this workbook, and I'd like a safeguard.

Thanks Mick, in the time it took me to type the above you'd already answered it.

Thanks very much