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”
Then Go To “Options”
Now click on “Trust Center” from left hand side
Now select “Trust Center Settings” from the right side pane
Now select “Trust Center Settings” from the right side pane
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)”
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