Skip to Content
0
Jan 08, 2009 at 01:58 PM

add own Sub/Function into the SAPBEX.xla

26 Views

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?