How to run macro without open an excel sheet

[yarondavid]

Hi,

I have a VBA macro that run from other excel sheet (I add a 'Custom Button' in the Excel's menu bar).
But when I run the macro from "target" sheet, an excel sheet that contains the macro in ThisWorkbook, is also opened.
How can I automatically close the "source" excel sheet which contain the macro in ThisWorkbook object.

Thanks

 

[Gavona]

Just add code to the end of the macro:

ThisWorkbook.Close SaveChanges:=False

If multiple users may use the macro then mark the file Read Only from Windows explorer.

You may also consider making the workbook hidden.

Gavin