How to enable macro in Microsoft office 2007

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.

Step 1:

Click on the Office button left side top corner then click the Excel option.

Office 2007 macro step 11

 

 

 

 

 

 

 

 

 

 

 

 

Step 2 :

Click on Trust Center  option prompt the Excel Options window then click on the Trust Center Settings option.

Office 2007 macro step 2

 

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.

 

Office 2007 macro step 3

Now your excel sheet has been enabled macro successfully!  then can you modify or edit your self.


 

Save

One thought on “How to enable macro in Microsoft office 2007

  1. prabawp Post author

    thanks for your comments. actually i am working for that, i will post good articles in my website as soon as possible.

Leave a Reply

Your email address will not be published. Required fields are marked *