Risks of Macros
The Risk of Macros
A primary security risk in using macros is that macros can be programmed to act like viruses and delete files and cause a lot of damage to your system. Depending on the service pack installed you may get an alert every time you open a file that contains a macro. It would be a good security practice to never enable macros unless you are completely confident and aware of the source. Any unsigned macros are automatically disabled. Any macros that are unknown or downloaded, the Microsoft security system will think it has a virus.
A security service ran by Carnegie Mellon in 1999 alerted Microsoft Office of a major security oversight. It was found from a macros virus people were using in Microsoft. “Since the 1999 incident Microsoft has made provisions to lower the risk of anymore problems. So needless to say it is important that the user be educated in the precautions that Microsoft has taken in keeping the user computer safe. Educating the user will not only let the user know why these security measures are needed. Like in Microsoft 2007 and newer the extension in the file name is added security for the user and the Microsoft program to identify trusted macro enabled file ("Excel Macro Security", 2012). Also the user will know not to enabled or disable certain security settings” (rns2undone)
By locking cells from right-clicking the format cells in the column desired and then finalizing that move from going to the review tab and clicking Protect Sheet,you can protect your worksheet.You can enter a password, functions will be ‘greyed’,and nothing can be modified.
Risk Using Macro in Excel - Research Paper - Rns2Undone www.studymode.com › Home › Religion & Spirituality
Richard L. Meade rlmeade@cox.net Eastern Standard Time
A primary security risk in using macros is that macros can be programmed to act like viruses and delete files and cause a lot of damage to your system. Depending on the service pack installed you may get an alert every time you open a file that contains a macro. It would be a good security practice to never enable macros unless you are completely confident and aware of the source. Any unsigned macros are automatically disabled. Any macros that are unknown or downloaded, the Microsoft security system will think it has a virus.
A security service ran by Carnegie Mellon in 1999 alerted Microsoft Office of a major security oversight. It was found from a macros virus people were using in Microsoft. “Since the 1999 incident Microsoft has made provisions to lower the risk of anymore problems. So needless to say it is important that the user be educated in the precautions that Microsoft has taken in keeping the user computer safe. Educating the user will not only let the user know why these security measures are needed. Like in Microsoft 2007 and newer the extension in the file name is added security for the user and the Microsoft program to identify trusted macro enabled file ("Excel Macro Security", 2012). Also the user will know not to enabled or disable certain security settings” (rns2undone)
By locking cells from right-clicking the format cells in the column desired and then finalizing that move from going to the review tab and clicking Protect Sheet,you can protect your worksheet.You can enter a password, functions will be ‘greyed’,and nothing can be modified.
Risk Using Macro in Excel - Research Paper - Rns2Undone www.studymode.com › Home › Religion & Spirituality
Richard L. Meade rlmeade@cox.net Eastern Standard Time