You can also choose to permanently enable macros for any files that you open. When you open an Excel file containing macros on Windows, by default you’ll get a notification that the file contains macros and be given the option to enable or disable them. Excel works slightly differently on Windows and Mac, so the exact steps will depend on the operating system that you’re using. If you are certain that a document containing macros is safe, enabling macros in the document is quick and easy to do. Many macro viruses will access contact lists and send out emails from your account, allowing the viruses to spread. You should only do so if you trust the document.Įven if it was sent to you from someone you know, you should be wary. When you open a document containing macros, you will be asked to confirm that you want to enable macros.
These malicious macros can spread viruses and other forms of malware, which can have serious consequences.įor this reason, macros are disabled by default in Excel. It is possible to insert macros into Excel documents that can cause serious harm to your computer. That’s because when you open a file created by someone else that contains macros, you have no idea what those macros are. Macros can make your life easier, but there is a risk when using them. Why Would You Want to Disable Macros in Excel? This allows you to create highly complex macros that can do almost anything you wish. You can make macros even more powerful by using the Visual Basic (VBA) programming language to write your own macros rather than merely recording them. Inserting them one at a time isn’t ideal, but a macro can insert as many sheets as you would like by repeating the same steps for you, over and over again. For example, you might want to insert multiple sheets into your document. Running your macro will then perform that same sequence of actions as many times as you wish. In their simplest form, you can record a sequence of actions in Excel and save them as a macro. They can save you from performing repetitive tasks in Excel.
What Are Macros?Ī macro is a set of instructions that tells Excel to perform an action or sequence of actions. Here’s how to enable or disable macros in Excel.
Turning them back on is simple enough to do, however. That’s why macros are disabled by default in Excel. Macros come with risks-it’s possible for people to create malicious macros that can infect your computer with malware when you open them.
0 kommentar(er)
