Preview

Risk Using Macro in Excel

Good Essays
Open Document
Open Document
468 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Risk Using Macro in Excel
The Risk of using Macros in Excel
What is a primary security risk that user should acknowledge when using macro?
Well I think that keeping control of the macros in the Microsoft programs are very important to the security of the user’s computer. From what I read in the reading and a little research letting the wrong macro get a hold of your computer can be a disruptive to your computer. From what I found out in one of the websites called ComputerWeekly.com Saran(2001), “ an advisory notice by Cert, the security service run by Carnegie Mellon University , has alerted user to a major security oversight in Microsoft Office” (para. 2). This was discovered due to a macro virus that was spread in 1999 to people using Microsoft (Saran,(2001). So with that said the user needs to pay attention to the security setting that Microsoft has implemented.
Why is it important to educate users of these risks once their dilemma is resolved? Since the 1999 incident Microsoft has made provision 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.
What Type of support Strategies should be utilized to ensure risk are minimized?
According to the article I read from the website ExcelFunctions.net. The steps to take are simple. In Microsoft 2003 there are four security levels to indicate the tolerance of macro to the user’s computer ("Excel Macro Security", 2012). This option is also in Microsoft 2007 and newer the user can also save the file with a distinct suffix at the end of the file name to

You May Also Find These Documents Helpful

  • Good Essays

    Open the excel file which is password protected and goto Macro's (I am using Office 2007 so the menu's maybe different View >> Macros). Click on "Record Macro >> OK" and then click on "Stop Recording" from the same menu. Now goto "View Macros", you will find a Macro with a default name E.g. Macro1 - Select the macro name and click on Edit. Now a Visual Basic Editor opens up. Re-place the default code and Paste the below code.…

    • 1023 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Is3110 Week3 Quiz

    • 347 Words
    • 2 Pages

    2. Using the user domain, define risks associated with users and explain what can be done to mitigate them.…

    • 347 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    BA L2 Unit 14

    • 449 Words
    • 2 Pages

    1.4 Confidential business information should be properly secured. If it isn't, data can potentially be misused. For instance, making sure the files you are using have a password put in place to…

    • 449 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Excel Chapter 8 Test

    • 599 Words
    • 10 Pages

    A point at which an entity covers its costs and starts to make a profit.…

    • 599 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    4. To prevent risk or threats of any kind you must safeguard all information stored on the database server. Employees have private information regarding business and customers stored on the database server and the loss or accidental leak of data could be a major hit to the company. This is why it is so important to use the risk management techniques of avoidance, transfer,…

    • 388 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Task B 307

    • 338 Words
    • 1 Page

    To make sure all records are properly secured you should have passwords on all computers and locks on all filing cabinets, making sure after every use you put paper files away and you lock your computer if you need to leave it. If you were to have visitors in the office were you secure document you should make sure you have put all away and not leave anything on show. When you have locked the cupboards you should keep the key with authorised person.…

    • 338 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    Even though Macros do it yourself software is ranked as one of Microsoft’s most useful tools to use. Based on the article by Lenning (2005) the primary security risk for users to know using macros is that many of these sites could have many different types of viruses. It is recommended that one should use caution when opening a new document. You should only open and used a trusted because some files can be corrupted and then they will spread viruses to your computer and most of the time you do not know where they come from. Depending on which version that you are going to use you will get a warning every time for a file that contains a macro. This is done because many times macros can be programmed to act like a virus. Before even considering opening a marcro site one has to remember that it can be dangerous to their computer. Because these viruses that pretend to be a marco they can get into your computer and delete files and cause other damage to your system as viruses are meant to do. It’s a good idea to be careful when you enable macros. There are a couple of ways to help keep your computer safe; I would look at installing the lasts service packs and updates for Microsoft. I would also make sure I had a strong firewall/anti- virus program on my computer. But, the main way to help keep your computer safe I feel is to pay attention to what you are using, what sites, and what you…

    • 275 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    [242.1] Select and use appropriate methods to minimise security risk to IT systems and data…

    • 793 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    2.2 Describe how to manage risks associated with conflicts or dilemmas between an individual’s rights and the duty of care…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    even if they believe that there is a risk to the individual or even someone around them, this…

    • 3348 Words
    • 14 Pages
    Better Essays
  • Good Essays

    Pschy Case

    • 5180 Words
    • 21 Pages

    1) One reason consumers should be cautious with respect to information that is available on the World Wide Web is that…

    • 5180 Words
    • 21 Pages
    Good Essays
  • Good Essays

    Repeating a vague message over multiple modes of communication leaves the consumer wanting more information or ignoring the message because it does not apply to him or her. Campaigns leave the patient in control of the amount of additional information he or she needs to access.…

    • 770 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    2.2 Describe how to manage risks associated with conflicts or dilemmas between an individual’s rights and the duty of care…

    • 440 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1.2 Describe how to manage risks associated with conflicts or dilemmas between individual’s rights and duty of care.…

    • 498 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Unit 4 Health And Safety

    • 751 Words
    • 2 Pages

    4.4 Analyse how helping others to understand the balance between risk and rights improves practice.…

    • 751 Words
    • 2 Pages
    Good Essays