ronjon65
12-25-2015, 11:19 AM
For Excel 2010, I have macros set to "disable all macros with notification".
The first time I start a file, I get the notification and allow the macro. However, upon closing Excel and reloading the same file, the notification does not come up and the macro is automatically enabled. If I change the filename and reload, then the notification comes up.
Is this the expected behavior? It seems pretty unsecure. For example, if someone emailed me a legitimate file, I could adjust it and when they read it back on their end the macros would automatically be enabled. Maybe the confirmation on the Excel end is that the file size and date must be exactly the same too, before automatically allowing macros to be enabled?
The first time I start a file, I get the notification and allow the macro. However, upon closing Excel and reloading the same file, the notification does not come up and the macro is automatically enabled. If I change the filename and reload, then the notification comes up.
Is this the expected behavior? It seems pretty unsecure. For example, if someone emailed me a legitimate file, I could adjust it and when they read it back on their end the macros would automatically be enabled. Maybe the confirmation on the Excel end is that the file size and date must be exactly the same too, before automatically allowing macros to be enabled?