ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Are Excel Macros Adversely Affected by inserting an Object in a ce (https://www.excelbanter.com/excel-programming/318676-excel-macros-adversely-affected-inserting-object-ce.html)

DGA in VA

Are Excel Macros Adversely Affected by inserting an Object in a ce
 
I have an Excel spreadsheet with multiple workbooks.

It has a checklist workbook where another workbook calculates compliance
based on the answers in the checklist workbook.

As an annotation to the checklist workbook, I inserted objects -- excerpts
of a Word or PowerPoint or Access file. The cell I inserted the object into
was either designated as a comment column or was not part of the checklist.

I was told to remove the objects because no one knew whether or not the
object would adversely affect the macros.

Inserting the object made the spreadsheet huge. But I believe reducing the
excerpts to their essential elements and inserting them in cells not involved
in the macros would have no adverse affect on the macro.

Does anyone know if I am mistaken?

Sharad

Are Excel Macros Adversely Affected by inserting an Object in a ce
 
Hello,

I had inserted windowrd / word pad objects and worked with them through
code also.

I don't a reason why should it have adverse effect on macros, especially
when you are leaving them alone.

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com