Greetings everyone.
I'm running a series of forms, combining several information for my company, among them a system that generates graphs for monthly deliveries. Since the userform does not support graphs, the alternative I found was for the macro to save them as .gif files which are loaded by the form as an image. The system is working perfectly, however, if I haven't opened the sheet containing the graphs before running the macros, the images won't load. I figure the graphs are only loaded once I open the sheet, which should be no problem as long as I have the sheets visible. However, once the coding is finished, I plan on hiding the workbook and leaving only the forms visible, so the images wouldn't work any longer.
Any ideas on commands to make the graphs be loaded without opening the sheets?
I'm running a series of forms, combining several information for my company, among them a system that generates graphs for monthly deliveries. Since the userform does not support graphs, the alternative I found was for the macro to save them as .gif files which are loaded by the form as an image. The system is working perfectly, however, if I haven't opened the sheet containing the graphs before running the macros, the images won't load. I figure the graphs are only loaded once I open the sheet, which should be no problem as long as I have the sheets visible. However, once the coding is finished, I plan on hiding the workbook and leaving only the forms visible, so the images wouldn't work any longer.
Any ideas on commands to make the graphs be loaded without opening the sheets?
