How to call a sheet-specific macro

[4am]

Hi.
I have a sheet that uses a plugin to run a SQL query into excel. In that sheet is a button attached to a sub called 'update_now'
I want to run 'update_now' from another sheet, but just assigning the button to the macro doesn't work, because the macro is looking in the current sheet.

I think the easiest thing for me to do would be to make another macro that "calls" that sheet-specific macro.

Any help? I've tried Application.Run ("'update_now") and it doesn't work.

ADDITIONAL INFO: Not sure if it matters, but the code for that macro is in its own VBA Project called 'dataplug98.xla' and it's own module called 'dataplug_code'

EDIT 2: Application.Run "'YourAdd-in.xla'!YourSubName" - works but then I get the error because it's trying to run from the sheet I'm on instead of the sheet that the macro should run from... I may need to edit the code for the add-in to point to a specific sheet?

[patel45]

put the sub update_now in a module in modules, not in sheet, then assign it to button

[Solus Rankin]

You can copy and past the macro to the module for the sheet you're trying to run the code on, and change all the sheet references to the correct sheet. Or you can copy the macro to the workbook module and change the sheet references to ActiveSheet.