Some of your Microsoft office excel documents maybe written macro using by visual basic application to save your works hours by automating simple, repetitive tasks in excel sheets. this kind of documents need to be enable macro in your excel sheets.
Click on the Office button left side top corner then click the Excel option.
Step 2 :
Click on Trust Center option prompt the Excel Options window then click on the Trust Center Settings option.
Step 3 :
In the Trust Center window you have to choose the Macro Settings, then select the : Enable all macros (not recommended; potentially dangerous code can run) options that’s it.
Now your excel sheet has been enabled macro successfully! then can you modify or edit your self.