"The macro may not be available in this workbook or all macros may be disabled"

[Jensen 3:16]

I get this message on a workshet I am doing in Excel 2007 that contains 1 VBA Code. I checked my macro settings and the "disable all macros with notification is checked". As a novice excel user, I am hesitant about the "Enable All Macros" because it says "not recommended, dangerous code can run". Can someone please explain what might happen if I do check that option?

 

[MARK858]

It's a bit of a vague question as it depends what someone has written in the code. As a very simple example you could have something like

For Each ws In ActiveWorkbook.Worksheets
        ws.Cells.ClearContents
    Next ws

which would empty all your cells in your workbook.

Unlike with a formula there isn't an undo action (unless you are using something like an autofilter).

But if you want to use macros then you have to have them enabled.

All the message is saying is check to make sure you know what you are running (or you trust the person who wrote it).

The enable all macros option do not use under any cicumstances

 

[MARK858]

I wasn't quite clear in the previous post.

But if you want to use macros then you have to have them enabled.
All the message is saying is check to make sure you know what you are running (or you trust the person who wrote it).

refers to the message you get with "disable all macros with notification is checked" which you should stick to.

I stress
The enable all macros option do not use under any cicumstances