On Apr 24, 3:32*am, JG wrote:
I've posted this before, just forgot the answer...sorry.

One of our programmers created a macro to prevent insert option, save as
option etc. for a specific workbook.

The macro has, however, now infected all workbooks. *Even if you create a
brand new workbook, all of these options are grayed out.

I know there is a reset code. *Could someone share it with me. *Thanks.

Try the fllowing

Dim cb as commandbar

for each cb in application.commndbars