Forum Discussion
DBOOTHV
Feb 13, 2023Copper Contributor
ENABLE MACROS - NOTHING WORK
Hi I need help with Macro settings I´m doing and Excel course in Coursera, when I downloaded the files that contain Macros Excel doesn´t allow me to run them. I have done the following and still doe...
- Feb 13, 2023
You didn't include the error message but my guess is you're getting a message saying macros are blocked because the workbook is not trusted. Essentially, you need to clear the author information from the file properties. Go to file | info | Properties | Advanced properties - remove the author information, save the workbook, close it and re-open it.
Patrick2788
Feb 13, 2023Silver Contributor
You didn't include the error message but my guess is you're getting a message saying macros are blocked because the workbook is not trusted. Essentially, you need to clear the author information from the file properties. Go to file | info | Properties | Advanced properties - remove the author information, save the workbook, close it and re-open it.
Berry_Source
Oct 06, 2023Copper Contributor
I followed your instructions and it didn't work for me. I deleted the author...any other suggestions? the "enable VBA macros" does not work either. SOS!!