Macros

Hi Anca,

Thank you for your question and welcome to the forum.

Do you save all your excel spreadsheets to you personal network drive?

If so, you need to add this location to the Trusted list. Here are the instructions:

1. Office Button - Excel Options
2. Trust Centre - Trust Centre Settings
3. Trusted Locations
4. Add New location
5. Choose your Personal Drive (s:) or whatever the folder is
6. Click OK and check the 'Add subfolders of this...' if you want.
7. If you then save the spreadsheet as a macro enabled worksheet through Office button and Save as and then Macro enabled workbook.

Next time you open the macro enabled workbook from that location you shouldn't get the security warning.

Maybe test this first to make sure you are happy.

I hope this answers your question.

Let me know.

Regards

Simon