How to Enable and Disable Macros in Microsoft Excel

<div dir="ltr" style="text-align: left;" trbidi="on"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiENunHpM0iiGnwtuFplpOk6zZIk8X0KJsGHMZ_DQyuaJTWE29DpRaqEWgD8gg82i91YInWCgZ1fW51D1i33mwIaKQ52vSlvLFRKWIyN8uNVIB7kT5WZnZVSWbYbUQYkGEUcyqBB8QpdJr/s1600/Security+Warning.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiENunHpM0iiGnwtuFplpOk6zZIk8X0KJsGHMZ_DQyuaJTWE29DpRaqEWgD8gg82i91YInWCgZ1fW51D1i33mwIaKQ52vSlvLFRKWIyN8uNVIB7kT5WZnZVSWbYbUQYkGEUcyqBB8QpdJr/s1600/Security+Warning.jpg" /></a></div><div style="text-align: justify;">While most macros are harmless and helpful when it comes to automating repetitive tasks. It also poses a security risks if it's coded with malicious purpose. It can contain unsafe codes that can be harmful when ran on your systems. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"></div><div style="text-align: justify;">Do make sure that you run macros that you own or from known sources and trusted publishers. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">To enable or disable and set macro security level in any office application that has VBA macros, Open the <b>Developer tab</b> or <a href="http://tutorpinoy.blogspot.com/2013/10/how-to-show-developer-tab-in-microsoft.html" target="_blank">See How to show Developer tab in Ribbon</a>. </div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"></div><div style="text-align: justify;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpplEwtumvBa7nU3O_ash1yu6pARiGbs5MSNL7e-eFp9oFubTTyLiuAlb5tjDdXZktPEfR8ymC_PBk9HWRNqJmRj8-ikx70tmfw2Ysll81GZhyphenhyphenfEmya6b1SIwzlCjacYoTMDKg3YO7cHBI/s1600/Trust+Center.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="213" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpplEwtumvBa7nU3O_ash1yu6pARiGbs5MSNL7e-eFp9oFubTTyLiuAlb5tjDdXZktPEfR8ymC_PBk9HWRNqJmRj8-ikx70tmfw2Ysll81GZhyphenhyphenfEmya6b1SIwzlCjacYoTMDKg3YO7cHBI/s400/Trust+Center.jpg" width="320" /></a></div><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjOtUZMsFNWk4iR4IycHjU4kHOFoH17adj8Lxlu2llUW8dp2gy4rXulscVohhd2I-aehuM3p-vgQAsAKT-6H3hkugxkLs38YC2HfmeACAfpsJA9-iZEb0hChCsljEVagBnlW1T7mAk-7z5x/s1600/Trust+Center.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"></a> <ins class="adsbygoogle" data-ad-client="ca-pub-1800470006166226" data-ad-slot="8848048043" style="display: inline-block; height: 90px; width: 200px;"></ins><script>(adsbygoogle = window.adsbygoogle || []).push({}); </script>Open up the Trust Center dialog window by clicking the <b>macro security</b> button on the <b>developer tab</b> or press (<b>Alt+LAS</b>) on your keyboard.<br /><div style="text-align: justify;"></div><br /><div style="text-align: justify;">The Macro settings tab on trust center dialog window has additional option buttons you can select to change macro level security.</div><div style="text-align: justify;"></div><div style="text-align: justify;"><br /></div><ul><li><b>Disable all macros without notification</b> - Select this option when you don't want to run all macros from unknown sources and untrusted publisher's location.</li><li>D<b>isable all macros with notification</b> (Default) - Select this option when you want to manage and check its trustworthiness before running the macro. </li></ul><span style="color: #cc0000;">If you have this option enabled, you just have to click the Options button of every security warning and select the Enable Content option button.</span><br /><ul><li><b>Disable all macros except digitally signed macros</b> - Select this option if you want to automatically run trustworthy digitally signed macros without raising notification.</li><li><b>Enable all macros (not recommend potentially dangerous code can run)</b> - Selecting this option is totally at your own risk, malicious codes can freely run and may cause damage to your system.</li></ul></div>

excel microsoft excel How to Enable and Disable Macros in Microsoft Excel

While most macros are harmless and helpful when it comes to automating repetitive tasks. It also poses a security risks if it's coded with malicious purpose. It can contain unsafe codes that can be harmful when ran on your systems. Do make sure that …

Read more »

How to show the Developer Tab in Microsoft Excel 2007

<div style="text-align: left;">By default, the Developer Tab is not shown on the Microsoft Excel's Ribbon.</div><div style="text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzHIdcir9xouCT0dhRr1bO_Mx_ykljZsNt2ynuCzT4mPLs1soY1Skcar7vSr-sapCFKUu2eNhRtFWYlcA66zcbjWb2Is78QshUj9eP-egKMsQHfn0P-KbCu3kk2hOZmYm3Cn36IJlunZ-3/s1600/Show+Developer+Tab.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="156" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzHIdcir9xouCT0dhRr1bO_Mx_ykljZsNt2ynuCzT4mPLs1soY1Skcar7vSr-sapCFKUu2eNhRtFWYlcA66zcbjWb2Is78QshUj9eP-egKMsQHfn0P-KbCu3kk2hOZmYm3Cn36IJlunZ-3/s640/Show+Developer+Tab.jpg" width="640" /></a></div><div style="text-align: center;"><br /></div><div style="text-align: center;">In order to show the Developer tab, Go to the File Menu and Click the <b>Excel Options</b> button.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKtkRZps99xsNJ2ReCyRbP-Eh6VZkPGReHU8Uwx8vBZFpyRkbQUDd_zZHFx_e1I9sIDFdiiJLcnJB-k3Bq5ANP3LPiRhjvKhrDFPfWjm_vobXOVlD6tkGR-rCNnV0MqcF4bJyZ-OMWa4_g/s1600/Excel+Options.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjKtkRZps99xsNJ2ReCyRbP-Eh6VZkPGReHU8Uwx8vBZFpyRkbQUDd_zZHFx_e1I9sIDFdiiJLcnJB-k3Bq5ANP3LPiRhjvKhrDFPfWjm_vobXOVlD6tkGR-rCNnV0MqcF4bJyZ-OMWa4_g/s400/Excel+Options.jpg" width="281" /> </a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: center;">On the Excel Options Window, Check the box <b>Show Developer tab in the Ribbon</b>.</div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlluZGpTiiu3nfpmk4iUjXJJYO41boi4sVBUOfpahY8plUm9L3V7gVexFXMfh3wFe5ycnlbxdaAwFFLz2PPlQkjQEhOXkc-u44SH8m69yGpkuMvfNv7HSWeAj_NnG-1q13unEEtyroAldc/s1600/Check+Show+Developer+Tab.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhlluZGpTiiu3nfpmk4iUjXJJYO41boi4sVBUOfpahY8plUm9L3V7gVexFXMfh3wFe5ycnlbxdaAwFFLz2PPlQkjQEhOXkc-u44SH8m69yGpkuMvfNv7HSWeAj_NnG-1q13unEEtyroAldc/s320/Check+Show+Developer+Tab.jpg" width="320" /></a> </div><div class="separator" style="clear: both; text-align: center;">Then Click OK, and that should show up the Developer tab.</div>

excel microsoft excel How to show the Developer Tab in Microsoft Excel 2007

By default, the Developer Tab is not shown on the Microsoft Excel's Ribbon.In order to show the Developer tab, Go to the File Menu and Click the Excel Options button. On the Excel Options Window, Check the box Show Developer tab in the Ribbon. Then C…

Read more »

The Ultimate Annual-Monthly Microsoft Excel Calendar template

<div class="KonaBody"><div class="separator" style="clear: both; float: left; text-align: left;"><br /></div>This Ultimate Excel Calendar Template allows user, company or any organization to create their own calendars. The template was created in VBA and may require the user to <a href="http://tutorpinoy.blogspot.com/2013/10/how-to-enable-and-disable-macros-in.html" target="_blank">enable macro</a> content in the document. <br /><br /><b>Annual Calendar Template:</b><br /><ul><li><b>Country</b> - Choose your home country.</li><li><b>Year</b> - Calendar year</li><li><b>First Day of the Week</b> - The first day of the week to be displayed</li><li><b>First Week of The Year</b> - Determines the work week number</li></ul>The screenshot below shows the calendar of the whole year and the holidays.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOYXtU83rk30d-zBbGGO-3i_xsgyafW12whoSOMlOMPlsCjRy1-IQUtqVtbRoePzhrzYpaiSB5ndVIqay0Y9wrPvkqBe-ZahSQb-RvnoAbaMmQ5z1RPdQ2R9f4twWl-1XSQ4WJVazMBEa6/s1600/Ultimate+Annual+Calendar+Template.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="484" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgOYXtU83rk30d-zBbGGO-3i_xsgyafW12whoSOMlOMPlsCjRy1-IQUtqVtbRoePzhrzYpaiSB5ndVIqay0Y9wrPvkqBe-ZahSQb-RvnoAbaMmQ5z1RPdQ2R9f4twWl-1XSQ4WJVazMBEa6/s640/Ultimate+Annual+Calendar+Template.jpg" width="640" /></a><input name="IL_IN_TAG" type="hidden" value="1" /></div><br /><br /><div style="text-align: center;">The video shows how does Ultimate Excel Calendar template work.</div><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="allowfullscreen" frameborder="0" height="266" mozallowfullscreen="mozallowfullscreen" src="https://www.youtube.com/embed/Mel-nGK-yHo?feature=player_embedded" webkitallowfullscreen="webkitallowfullscreen" width="320"></iframe></div><br /><br /><b>Monthly Calendar Template:</b><br /><ul><li><b>Month</b> - Choose which Month you want to display.</li><li><b>Year</b> - Month year.</li><li><b>First Day of Week</b> -  First day of the week to be displayed.</li><li><b>Country</b> - Choose your location</li></ul>This template will display the Holiday of the Month in the respective dates.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2s1H7G-3i-1lM0EBKEXrZhlopy98-GD9VQqEMDco3ujb7Jx-YOzrS-7qTYhmr4XN16BgYlFthBeKDx0EyD6rJwd85rfc5kvOhS667ebMVuDKVMtxUD50U6GCzaL16BrgUl8l_00NyzQ0U/s1600/Ultimate+Monthly+Calendar+Template_1.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="593" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2s1H7G-3i-1lM0EBKEXrZhlopy98-GD9VQqEMDco3ujb7Jx-YOzrS-7qTYhmr4XN16BgYlFthBeKDx0EyD6rJwd85rfc5kvOhS667ebMVuDKVMtxUD50U6GCzaL16BrgUl8l_00NyzQ0U/s640/Ultimate+Monthly+Calendar+Template_1.jpg" width="640" /></a></div><br />Download the <a href="https://docs.google.com/file/d/0B5TtjmHRH2vHWHJ2VzJXUVNLdkU/edit?usp=drive_web" rel="nofollow" target="_blank">Ultimate Annual-Monthly Excel Calendar</a> or post your email in the comment so I can send to you the template file. </div>

excel microsoft excel TEMPLATE The Ultimate Annual-Monthly Microsoft Excel Calendar template

This Ultimate Excel Calendar Template allows user, company or any organization to create their own calendars. The template was created in VBA and may require the user to enable macro content in the document. Annual Calendar Template:Country - Choose …

Read more »

Using Nested IFError - IF - VLookUp Functions in Excel

<div class="separator" style="clear: both; text-align: left;">In this example we'll be using three excel functions such as <span style="color: #b45f06;"><i><b>IFERROR</b></i></span>,<i><b><span style="color: #b45f06;"> IF</span></b></i>and <span style="color: #b45f06;"><i><b>VLOOKUP</b></i></span> functions. </div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><span style="color: #e06666; font-size: small;"><b>=IFERROR(IF(G3="","",VLOOKUP(G3,Sheet1!B:C,2,FALSE)), "No Match Found")</b></span></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_TYd4nxEPU5bBSfMwo9XxnwTGt-E2-y2xg7nkg3SUz3JPieAG1zsTqczYMYLyx2T9naaZtse2THdS1otxEVOpjeOZfLiMkKcHyeglvurs9IBfiIj1Zi6MizNcSh4wH2u_gt6rFZPUF11N/s1600/IfError-If-Vlookup.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_TYd4nxEPU5bBSfMwo9XxnwTGt-E2-y2xg7nkg3SUz3JPieAG1zsTqczYMYLyx2T9naaZtse2THdS1otxEVOpjeOZfLiMkKcHyeglvurs9IBfiIj1Zi6MizNcSh4wH2u_gt6rFZPUF11N/s1600/IfError-If-Vlookup.jpg" /></a></div><input name="IL_IN_TAG" type="hidden" value="1" /> <div class="separator" style="clear: both; text-align: left;">For this example, we'll use the above formula at Cell <span style="color: #cc0000;">"G4"</span>:</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">Initially, the formula says that if the value of <b>G3</b> is blank then set the value of <b>G4</b> to blank. Otherwise, look for the lookup value (<b>ID</b>)  in the table array and return the exact match in the second column (<b>Name</b>) . If the value is not found in the array then return a message to the user.</div><ul><li> <b>IFERROR(</b><i>'Formula to Evaluate', value-if-error</i><b>)</b> - Returns the specified value "No Match Found" if the formula evaluated returns an error value.</li><li> <b>IF(</b><i>logical_test, [value_if_true], [value_if_false]</i><b>) </b>-<b> </b>Logic test is a comparison between two values (<b>G3=""</b>), test's if the value of G3 is empty. Followed by two arguments which are the <i>value_if_true</i> and <i>value_if_false</i>. If the value of G3 is equal to blank then do nothing or set the Cell's value to blank. While, if the value if G3 is not equal to blank then evaluate the next function.</li><li><b>VLOOKUP(</b><i>lookup_value, table_array, col_index_num, [range_lookup]</i><b>)</b> - Looks up  the value of <b>G3</b> in the table array <b>Sheet1!B:C</b> and return the value of the exact match from the column <b>2</b>.</li></ul>

excel microsoft excel Using Nested IFError - IF - VLookUp Functions in Excel

In this example we'll be using three excel functions such as IFERROR, IFand VLOOKUP functions. =IFERROR(IF(G3="","",VLOOKUP(G3,Sheet1!B:C,2,FALSE)), "No Match Found") For this example, we'll use the above formula at Cell "G4":Initially, the formula s…

Read more »