Chart Resizing Problems

P

Pedro

Hi,
normally I use the following code to resize charts created by code:
'moving and resizing chart
ActiveSheet.Shapes("Last3Yrs").IncrementLeft -183.75
ActiveSheet.Shapes("Last3Yrs").IncrementTop 123.25
ActiveSheet.Shapes("Last3Yrs").ScaleWidth 0.8, msoFalse,
msoScaleFromTopLeft
ActiveSheet.Shapes("Last3Yrs").ScaleHeight 0.97, msoFalse,
msoScaleFromTopLeft

Now that I have changed the monitor of my computer I have realised that
these resizings and the way that they appear on the spreadsheet are
influenced by the resolution of the monitor.
The result was that all my charts created by VBA are in a complete strange
size.
Does anyone knows what changes should I make to the code in order for charts
size not be influenced by the monitor resolution.

Best REgards
Pedro
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you programatically format embedded charts 3
Launching PowerPoint from an Excel application 2
Need macro to insert chart w/ FIXED size & location 2
Reposition Chart Macro 6
find name of a chart 5
Visual Basic Chart Moving 11
Another VBA Chart problem Excel 97 3
ChartingQuestion 5

Top