Part 1: Prepare to operate on Excel 2010 macros<\/h2>\n
For example, if there is no Developer tab in MS Excel 2007\/2010 menu bar, it is necessary to add it to Excel menu bar first, otherwise, you could not create macros in MS excel. If there is, bypass this part and go on to part 2<\/a>.<\/p>\n 1. Click File<\/strong> tab, and click Options<\/strong>.<\/p>\n 2. Click Customize Ribbon<\/strong> tab in Excel options window. In the Customize the Ribbon category, in the Main Tabs<\/strong> list, select Developer<\/strong>, and click OK.<\/p>\n Then you can see Developer in Excel menu bar, and Macros is in Developer<\/strong> tab, Code<\/strong> group.<\/p>\n If you are ready, let\u2019s begin to enable macros, create macros and delete macros<\/strong> in Excel 2010.<\/p>\n In Excel default settings, Macros is disabled in Excel 2007\/2010. Therefore, if you want to do anything about Macros in workbook or worksheet, such as create Macros or delete Macros in Excel, Macros has to be enabled at first.<\/p>\n 1. On Developer<\/strong> tab, in Code<\/strong> group, click Macro Security<\/strong>.<\/p>\n 2. In following pop-up Trust Center dialog, click Macro Settings, and check Enable all macros (not recommended; potentially dangerous code can run)<\/strong><\/em> under Macro Settings<\/strong> option. Click OK.<\/p>\n Now Excel 2007\/2010 is ready for you to create macros.<\/p>\n Step 1:<\/strong><\/em> Click Record Macro<\/strong> button in Developer <\/strong>tab.<\/p>\n In Developer – Code <\/strong>group, there is a button Record Macro<\/strong>. If you want to create macros in Excel 2010, it is enough for you to do with “Record Macro” button. Just click it when you think you are ready to create a macro.<\/p>\n Then Record Macro dialog appears, and several options have to be set in this dialog before macro creation.<\/p>\n Step 2:<\/strong><\/em> Set Macro parameters for new macros in Record Macro<\/strong> dialog.<\/p>\n 1. Macro name<\/strong><\/p>\n Macro name is the direct description about the macro you are going to create. So give it a name with actual meaning could let you easily distinguish to run it later in Excel workbook. For example, if you want to bundle steps of creating title in table into macro, you can call macro “CreateTableTitle”<\/em>.<\/p>\n 2. Shortcut key<\/strong><\/p>\n In Excel 2010, Shortcut key is set to begin recording steps into a macro, and used to run macro after creation. So we had better set different shortcut key for different macros that macros would not be confusing, when we use shortcut key to run Macro in Excel workbook.<\/p>\n 3. Store macro in<\/strong><\/p>\n Macros in Excel can apply to This Workbook, New Workbook or Personal Macro Workbook<\/em><\/strong>. This option specifies where the macro can be used.<\/p>\n 4. Description<\/strong><\/p>\n In Description, anything can be set as you like. You can describe the macro more in details, or record the macro creation date etc.<\/p>\n Step 3:<\/strong><\/em> Record operation steps into macro.<\/p>\n After click OK in Record Macro, do what you want to record in macro. When you finish, click Stop Recording<\/strong> in Developer – Code<\/strong> group.<\/p>\n Macro has been created now. If you would like to see the steps in macro, click Macros<\/strong> in Code group. In opening Macro dialog, click the Macro you want to see details and click Edit button in the right side.<\/p>\n Then a new VBA window shows up. The operation steps and other information of all of Macros you just see are listed with VBA code. Even though you want to change Macro, change the VBA code now is allowable.<\/p>\n Here excel 2010 macros will be deleted in Macros dialog.<\/p>\n 1. Click Developer<\/strong> tab, and click Macros<\/strong> in Code group. Macros dialog pops up.<\/p>\n 2. All of Macros available to this Excel workbook are listed in Macros dialog. Click on Macros you want to delete, and click Delete<\/strong> button on the right side.<\/p>\n No matter you want to edit, run or delete Macros in Excel, the steps are similar to the above steps.<\/p>\n Related Articles:<\/strong><\/p>\n Macro is not only usually used in Word, but also used in MS Excel widely, because of different…<\/p>\n","protected":false},"author":1,"featured_media":126290,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-2677","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office-documents"],"_links":{"self":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/comments?post=2677"}],"version-history":[{"count":5,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2677\/revisions"}],"predecessor-version":[{"id":7089,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/posts\/2677\/revisions\/7089"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media\/126290"}],"wp:attachment":[{"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/media?parent=2677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/categories?post=2677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.isunshare.com\/blog\/wp-json\/wp\/v2\/tags?post=2677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"open](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/open-office-excel-options.png\")
<\/a><\/p>\n![\"add](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/add-developer-ribbon-to-excel-main-tabs.png\")
<\/a><\/p>\nPart 2: Enable, Create and Delete Macros in MS Excel 2010<\/h2>\n
\n
Section 1: How to enable Macros in MS Excel 2010<\/h3>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/choose-macro-security.png\")
<\/a><\/p>\n![\"enable](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/enable-macro-in-excel-2010.png\")
<\/a><\/p>\nSection 2: How to create macros for MS Excel 2010 workbook<\/h3>\n
![\"choose](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/choose-to-record-macro.png\")
<\/a><\/p>\n![\"set](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/set-macro-parameters-to-record-macro.png\")
<\/a><\/p>\n![\"stop](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/stop-macro-record.png\")
<\/a><\/p>\n![\"select](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/edit-macros-in-excel-2010.png\")
<\/a><\/p>\n![\"edit](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/edit-excel-macro-in-vba.png\")
<\/a><\/p>\nSection 3: How to delete or remove macros from Excel 2010 workbook<\/h3>\n
![\"remove](\"https:\/\/www.isunshare.com\/blog\/wp-content\/uploads\/2015\/06\/remove-macros-from-excel-2010-workbook.png\")
<\/a><\/p>\n\n