Hi,

You could put this in (say) the workbook open event and set it to TRUE in
workbook close

Private Sub Workbook_Open()
With Application.CommandBars("Worksheet Menu Bar").Controls("&Tools")
.Controls("&Macro").Enabled = False
End With
End Sub

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Jeremy" wrote:

I have macros that are automated on excell 2003 and I am not wanting users to
view or execute macros from clicking on tools then macro. How would I gray
out this option?


Thank you