Hi All,
First off, thank you in advance for your help. I’m working on a project for work and I’ve been stuck on this “issue” for the past few weeks so your input is much appreciated because at this point I’m stumpedL


My workbook:
I have a sheet in my workbook that contains 50 graphs with a text box beneath each graph (50 text boxes in total). The graphs show performance metrics for stores, and the text box contains notes. The idea is for a district manager to visit one of his/her stores, sit down with the manager to review the performance metrics (aka graphs), and then enter his or her action plan into the text box. The next time the district manager visits the store, he/she can sit down with the manager, pull up the previously entered action plan, and use it to check progress.
My problem:
My current set up for this involves a heavy amount of VBA, which is taking up too much space and causing the document to crash frequently. I currently have an edit button, which returns all previously saved notes and allows the user to enter new notes. With the notes pane open, a save button takes all of the notes (previously entered and new) and transfers them to the separate file. I’m using this system for each of the 50 notes panes, and it’s simply taking up too much space. Do you have any recommendations for how I can keep the functionality of my workbook while reducing the file size?
Thank you,
Benjamin

Hi,

Perhaps a redacted copy of your file would help.

Here are some screen shots

Excel_Screenshot_Help (2).png

Excel_Screenshot_Help (4).png

Hi,

Thanks for the screen shots. But, if your problem is the file crashing because of the file size it could be a memory issue. If you can let us see the code so that we can see how to reduce it in size or revamp it.

Hi,

If you requested help on other sites it would be nice if you let us know.

http://www.excelforum.com/excel-prog...-workbook.html

http://www.mrexcel.com/forum/excel-q...ate-graph.html

It will save our time as too whether we need to help you.