Option to enable macros not available...anyway to reset?

[jeffreybrown]

I've run across this a couple of times and the workbook was always small enough to start over...but not this time.

I was setting up a cell to switch between a Deployment (workbook and sheets locked) state and a Development (not locked) state and received a debug while testing the code so just ended and closed the workbook. Nothing out of the usual, but now when opening the workbook I can't enable the macros.

This only happens on this workbook, other macro enabled workbooks are fine. I transferred this workbook to a co-workers computer and the same thing happens so it appears individual to this one workbook.

Any thoughts?