Macro wont run with macros enabled

**tek0011** · 09-09-2011, 03:42 PM

I cannot seem to get this macro to run, even though all macros are allowed.
It will run from the actual macro screen but not the spreadsheet.

Ideas?

Or, better yet, is there a way to create a button like this, that will not require others to enable macros?

Edit: I believe I fixed this by creating another macro after macros were enabled.
However, will others that use this spreadsheet have to enable macros to use this button?

**Kinchen** · 09-09-2011, 04:11 PM

I was able to get your excel to work with this code:


Option Explicit

Sub Macro1()
'
' Macro1 Macro
'
    Sheets("Sheet1").Range("E12:F1100").Select             'I added the Sheets reference
    Selection.ClearContents
End Sub

I also right clicked on the button and made sure it was associated with the right Macro and everything worked from there.