Hello Experts,
i have written a makro for a worksheet. When you click a button some actions are done. The macro consists of a Public Sub CommandButton1_Click() routine which uses a module. These two things i would like to include into the SAPBEX.xla, so that it is provided to all the workbooks.
I have read something with the SAPBEXRefresh Function but i dont want to execute it every time on variable refresh.
How can i enhance the SAPBEX.xla with my own written coding?