Saving without macros excel 2007

[george1982]

Hi,

I've tried searching the forum but I've got an error

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 71 bytes) in /home/eforum/public_html/search.php on line 1155

I have following macro, what worked just fine in 2003. Now I'm working with 2007 and I can't set up the Microsoft Visual Basic for Applications Extensibility library ...

Here's the code:

Please Login or Register  to view this content.

Thanks,
George

[Andy Pope]

Have you enable access to VBA projects?

Office Button > Excel Options > Trust Center > Trust Center Settings > Macro Settings > Trust access to VBA project object model.

[george1982]

Hi,

This is what I did and now everything is just fine. This is what I did

I had the 1004 error in Excel 2007. Solved by:

1) Excel Office Button > Excel Options > Trust Center Settings > Trusted Locations > Add New Location - Browse to secure location where the add-in is located.

2) Excel Office Button > Excel Options > Trust Center Settings > Macro Settings - Put checkmark next to Trust Access to the VBA
Project Model.

Thanks for the help Andy,
George