Excel Security Settings not letting Macros Run?

[chelberg]

I'm not sure what happened or what my security settings need to be anymore. I had a workbook that I was rolling into a new year, all I did was saved the old workbook with a new name. When I try to run the macros I get a "Security Risk" warning and all my macros are blocked.

When I view the macros it looks like they're in the workbook, this is the only workbook I have open.

I have gone into VBA and deleted anything that was in there and then copied and pasted the old macros into the new workbook. Is there anything I can do to make this work or do I need to create a new workbook from scratch? The macros in the old workbook still work just fine.

Thanks for any help.

 

[Beneindias]

Hello.

Click with right button of mouse in the file, go to properties and unlock the macros there.

It's a checkbox on the bottom of the General tab.

Hope it helps

 

[FGaxha]

Try this:
Right click on workbook, Properties, Select Unblock box, hit OK

 

[chelberg]

One of the Attribute boxes?

 

[FGaxha]

Try this:
File-Trust Center-Trust Location-Add new location- browse new ,,,,,

 

[chelberg]

Try this:
File-Trust Center-Trust Location-Add new location- browse new ,,,,,
View attachment 84336

THANK YOU!!! I had to allow it to access the the network as well. I tried that yesterday and it wasn't happy with me then. New Month I guess.