Call sub from multiple worksheets

Hi,

I'm new to VBA. I'm trying to call a Sub from two different worksheets of the same workbook, but I'm getting an error. Here's what I have.

In Modules -> Module1 I have:

Please Login or Register  to view this content.

In Microsoft Excel Objects -> Sheet1 I have:

Please Login or Register  to view this content.

In Microsoft Excel Objects -> Sheet2 I have:

Please Login or Register  to view this content.

When I click the button while on Sheet 1, it works. When I click the button while on Sheet 2, I get "Compile error: Sub or function not defined." Is there a way to get this to work? Thanks!

Hi and welcome to the forum

Could you attach the file so we can see it in context? Easier to diagnose these issues when we can poke around the file, especially when there looks to be little wrong with the code example above.

EDIT:
Attached is a file I set up exactly as you describe in your post, and all seems to work fine for me...

BSB