Thursday, December 12, 2013

Change Macro Security in Excel 2010

Macro means some automated tasks which mainly created with Visual Basic for Applications (VBA). It is generally used in Microsoft Office package (Microsoft Word, Excel, PowerPoint etc.) Macros could be created in a destructive format which could be harmful to a computer and can spread a virus. It may infect the other files on your PC.
By default Macros are disabled in Microsoft Office for security purpose. Enabling these Macros is very easy but the Microsoft Office team knowingly has kept it deeper inside Options, so that until unless someone knows about its features, never can activate or enable.
By following steps stated below you can enable Macros in your Microsoft Office;
At First you click on the “File menu”
 
Excel 2010
Then Go To “Options”
Excel 2010
Now click on “Trust Center” from left hand side
Now select “Trust Center Settings” from the right side pane
Excel 2010
Then Click on “Macro Settings” from Left pane
At the right side pane you can see Macro Settings. By default “Disable all macros with notification” will be selected.
Change the selection to “Enable all macros (not recommended; potentially dangerous code can run)”
From now on you can open any file which contains any macros. Please be sure before enabling all macros that it must come from any trusted source otherwise it may be harmful to your computer, can corrupt your Microsoft Office and your Operating System also.

0 comments:

Post a Comment

Copyright © Apps computing All Right Reserved
Designed by Harman Singh Hira @ Open w3.