Private Sub CommandButton1_Click() Call Macro1 End Sub perhaps? be a little more specific
F ForSale Sep 8, 2004 #1 Private Sub CommandButton1_Click() Call Macro1 End Sub perhaps? be a little more specific
G Gord Dibben Sep 8, 2004 #2 Set your security to medium and you will asked if you want to enable macros when the workbook opens. Tools>Options>Security>Macro Security. If running Excel 97, enabling macros is either on or off. No levels of security. Gord Dibben Excel MVP On Tue, 7 Sep 2004 20:21:04 -0700, TOM <[email protected]> wrote:
Set your security to medium and you will asked if you want to enable macros when the workbook opens. Tools>Options>Security>Macro Security. If running Excel 97, enabling macros is either on or off. No levels of security. Gord Dibben Excel MVP On Tue, 7 Sep 2004 20:21:04 -0700, TOM <[email protected]> wrote:
