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