Hello

I wonder if anyone can help.

I compile performance stats for my company using an excel spreadsheet onto
which I have added buttons that open userforms that display graphs of the
stats that are held in separate hidden worksheets.

The problem is that I do this in a very inefficient way.

Everytime I update the graphs I:-

1. Unhide the worksheet with the graph
2. Copy the worksheet into paint
3. Cut out the graph and save as a paint file in a folder on my hard drive
4. Open the VBE and select the userform.
5. Change the picture file to the new version of the paint file
6. Close the VBE and hide the worksheet with the graph

Does anyone know of an easier way of doing this?

Any assistance would be much appreciated

Many thanks in advance and kind regards, Nick

John Walkenbach has an easier way:

http://www.j-walk.com/ss/excel/tips/tip66.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Nick" <(E-Mail Removed)> wrote in message
news:25422CDE-7269-4DA4-8532-(E-Mail Removed)...
> Hello
>
> I wonder if anyone can help.
>
> I compile performance stats for my company using an excel spreadsheet onto
> which I have added buttons that open userforms that display graphs of the
> stats that are held in separate hidden worksheets.
>
> The problem is that I do this in a very inefficient way.
>
> Everytime I update the graphs I:-
>
> 1. Unhide the worksheet with the graph
> 2. Copy the worksheet into paint
> 3. Cut out the graph and save as a paint file in a folder on my hard drive
> 4. Open the VBE and select the userform.
> 5. Change the picture file to the new version of the paint file
> 6. Close the VBE and hide the worksheet with the graph
>
> Does anyone know of an easier way of doing this?
>
> Any assistance would be much appreciated
>
> Many thanks in advance and kind regards, Nick

This is spot on Jon many thanks

Nick
"Jon Peltier" wrote:

> John Walkenbach has an easier way:
>
> http://www.j-walk.com/ss/excel/tips/tip66.htm
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> Peltier Technical Services, Inc. - http://PeltierTech.com
> _______
>
>
> "Nick" <(E-Mail Removed)> wrote in message
> news:25422CDE-7269-4DA4-8532-(E-Mail Removed)...
> > Hello
> >
> > I wonder if anyone can help.
> >
> > I compile performance stats for my company using an excel spreadsheet onto
> > which I have added buttons that open userforms that display graphs of the
> > stats that are held in separate hidden worksheets.
> >
> > The problem is that I do this in a very inefficient way.
> >
> > Everytime I update the graphs I:-
> >
> > 1. Unhide the worksheet with the graph
> > 2. Copy the worksheet into paint
> > 3. Cut out the graph and save as a paint file in a folder on my hard drive
> > 4. Open the VBE and select the userform.
> > 5. Change the picture file to the new version of the paint file
> > 6. Close the VBE and hide the worksheet with the graph
> >
> > Does anyone know of an easier way of doing this?
> >
> > Any assistance would be much appreciated
> >
> > Many thanks in advance and kind regards, Nick
>
>
>