Macro Problem

Hello Sam,

Wicked program. I've been frustrating myself testing different applications in a effort to develop a ecommerce site for a while now and XLE is just what I've been searching for.

With that said, I am running into some problems using the evaluation copy of XLE.

Anytime I attempt to interact with the program - for instance, selecting 'New Ad' - a Excel window pops up stating "The cell or chart you are trying to change is protected and therefore read-only. To modify a cell or chart...".

When I click 'OK', a new window pops up titled "Macro Error" stating "Macro error at cell: [XLEcom.xls]Temp1!DO725" and offers three choices "Halt", "Step", "Continue". When I select "Continue", a similar error message pops this time saying " Macro error at cell: [XLEcom.xls]Temp1!DO732 ". When I select continue from this pop up, I return back to "Product Design" tab and nothing has changed.

Again, basically any interaction with XLE that changes data is met with similar error messages. I've uninstalled and reinstalled the program to no avail.

I've created a quick movie using Camtasia to illustrate the problem. The file can be downloaded here.

Please advise on how to correct this problem.



RE: Macro Problem


You are the first and only person who has experienced this problem. By the way, I could not run the avi movie file, but it was not necessary to answer your question.

It is typically helpful to know the following information about your OS and Excel, but in this case I don't think it really matters.

  • Your Operating System - i.e. Microsoft® Windows 95, 98, ME, 2000, XP, or any 2003 Server version
  • Version of Microsoft Excel (USA versions of Excel only) - i.e. Microsoft® Excel 2000, 2002 (XP), or 2003
  • XLEcom version number: The version number can be found in two places on the "Product Design" sheet. (1) In the bottom right corner and (2) by pressing the About button.

XLEcom was written and tested to run on USA versions of Excel.

This sounds like a problem with your particular Excel installation and not with the XLEcom program itself.

It could be that either your Excel Security is set too high not to allow macros to run, or that your Excel installation is some how corrupt to the point it cannot run macros properly. You may be able to fix the problem by reinstalling Excel over itself.

Sam Raheb
XLEcom Program Developer

Thanks, Sam.

Thanks, Sam.

I'm not certain what I did exactly, but the problem seems corrected.

I changed the "Macro Security" in Excel from low to medium, uninstalled and reinstalled XLEcom and now it seems to be working nicely.

I'm going to test the program further before making a final purchase decision, but so far I really like what I see.