Triggering a macro in a different sheet...

[Darth_Sullivan]

First, let me start by saying I've spent the last 2 hours going around in circles trying to search for the answer to this problem. So, sorry if the answer is out and I could not find it.

To put my question simply, I have a macro in Sheet2 named SaveNewRecord. Sheet1 contains the "Save" button that I want to trigger this macro. I only want this macro to run in Sheet2 and in no other sheet.

In Sheet1 I currently have:

Sheets("Sheet2").Activate.SaveNewRecord

Which I thought was my answer but, instead I get a Run-Time Error '424': Object Required

Can someone help me? Or at least point me in a positive direction?

Thank you.

 

[Redwolfx]

If you take the SaveNewRecord and put it in a module, then have the save button in sheet 1 call the macro, that should work for you.

 

[Darth_Sullivan]

This appears to work thus far. I swear I had already tried this too. Thanks for the quick response Red.