Protect Yourself from Macro Viruses [Potential Dangers of Enabling Macros in Excel-VB Workbooks From Unfamiliar Sources]

[This article was sent to members of my Excel-VB Club earlier today, and published here without password protection so interested others can benefit]

In introducing you to Excel-VB Programming, over the past weeks, I’ve demonstrated (using screenshot images and video tutorials) the important steps regarding How-To “Enable Macro” code in a workbook to run in your copy of MS Excel.

You will have noticed warning prompts thrown up by Excel anytime you try to open workbooks containing VBA code. This happens based on the default security setting in your copy of Excel.

There is an option provided to enable macros automatically, by default – but unless you’re sure no danger of unsafe workbooks being brought in, standard recommendation is that users always leave a layer of protection by requiring macros to be enabled.

This is especially if you’re not sure of the nature of code in workbooks you open e.g if they are from 3rd party sources you are NOT familiar with.

The need to have this security feature in place/enabled arose about decade and half ago, when Macro viruses were commonplace.

I still recall switching to Excel-VB from Lotus 1-2-3 Macro programming, and reading lots of material about potential dangers associated with downloading/opening Macro enabled workbooks from untrusted sources.

Back then there were tales of people having their PC files erased/damaged. Others have had banking and other sensitive data stolen.

Since those early days however, macro viruses have dropped off the radar in terms of occurrence.

But Microsoft and her community of MS Excel-VB developers have wisely not let their guard down.

They have maintained the security restrictions and warnings in place right into the latest versions of the application.

That has proven to be a wise strategy, because, as the article featured below reports, macro viruses have recently begun staging a comeback.

Click below to read the full piece:

Macro viruses reemerge in Word, Excel files.

[IMPORTANT: This blog's contents are being updated following the transfer to www.tayosolagbade.com from my former domain - Spontaneousdevelopment.com. As a result, some parts of it may not work properly for now. Quick Tip: If a link contains "spontaneousdevelopment.com", simply change it to "tayosolagbade.com" - and it should work. This applies to article links as well as image links. Work continues to update the links(in over 500 articles). Tayo K. Solagbade.]

Practical Livestock Feed Formulation Handbook

Available as a PDF ebook, and also as a spiral bound print manual (from me). Click here for details.

You can also get it as an PDF ebook via my online store.

Screenshot of ebook in online store

$82.5 USD to buy it from my online store (PDF download)

N8,000.00 [Eight Thousand Naira] for persons who wish to send payment direct to my bank account.

Payment of N50,000.00 gets you the physical handbook and software on CD with videos etc, PLUS practical one-on-one, in person training with me at a feed mill in Lagos, Nigeria.

Click here to contact me about purchasing this product.

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google Plus

Your Gifts for Subscribing

When you signup, you'll receive:

Submit the form below to get a download link to the PDF version of my newly revised

Once you submit the form below, you will be taken directly to the downloads page, just as an auto-response message will be delivered to your inbox, with links to the promised gifts.

I look forward to meeting and/or working with you!

Signature image - Tayo K. Solagbade

Tayo K. Solagbade*
Performance Improvement Specialist & Multipreneur
*Best Practice Farm Business Support Specialist
& Founder of the MS Excel Heaven Visual Basic Automation Club & Competition(www.excelheaven.biz)



Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app - watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.


Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

Powered by Optin Form Adder

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.


Get the Facebook Likebox Slider Pro for WordPress