Our Newly Posted Excel 2007 Article

If you’re using Microsoft Excel 2007 and about to open ProAPOD® Real Estate Investment Software for the first time, you might be interested in reading a newly written article posted on our website at http://www.proapod.com/Articles/excel-2007.html. The article is designed to show you how to reset security settings in Excel 2007 that prevent our real estate investment software from functioning properly, along with instructions on how to use the Excel 2007 Add-Ins tab to access our toolbar.

As you may know, ProAPOD® Real Estate Investment Software contains hundreds of VBA macros that virtually run the software program. Unless these macros are enabled when the program is first opened, even though the program opens, and the forms appear normally, the reality is that none of the calculations execute, the toolbar doesn’t appear, and well, the program just doesn’t work correctly.

This is why ProAPOD® emphasizes during its installation to ENABLE MACROS when opening the software for the first time. Because Windows will alert you that our real estate software contains macros and requires your approval. In this case, the user would simply check the box “Always trust macros from this source”, click the Enable Macros button, and that’s it. From that point forward ProAPOD® (which is digitally signed) behaves normally and no future warnings are given when the software is opened.

With previous versions of Excel, this was seldom an issue, and users, for the most part, simply followed instructions and were fine.

With Excel 2007, it’s not quite that easy. Foremost, because Excel 2007, by default, sets its security setting to the highest level, which in turn prevents any opportunity for our customer to enable the macros. He or she simply opens our real estate software unaware that things aren’t right. It’s not until a few forms are completed that it becomes obvious. Our Excel 2007 article shows step-by-step with screen shots how to reset the security level in Excel 2007 to get the macros running and the program fully functional.

The new “ribbon” concept introduced with Excel 2007 is another issue because it prevents our toolbar from displaying automatically when our real estate investment software is opened; the user is required to manually open it. Here’s the scoop. In past versions of Excel, developers were allowed to write VBA that replaced Excel’s toolbar with a customized toolbar while the application was open and than put things back to normal when the application was closed. That’s no longer the case. Microsoft doesn’t permit its toolbar to be hidden by an application’s customized toolbar, and now requires users to click an Add-Ins tab if they want to display it. Our article shows you how.

James Kobzeff

James Kobzeff has over thirty years experience as a realtor and investment real estate specialist. He is the developer of ProAPOD real estate investment software and freely shares his real estate investing articles.