AnsweredAssumed Answered

vrf Clear DataGridView

Question asked by VRFuser on Sep 16, 2008
Latest reply on Sep 16, 2008 by VRFuser
Amrik,

 

Below are 2 Excel Macro Commands that might help.

 

 

   ' This forces the Active Window to be visible.

    Application.ActiveWindow.Visible = True

  

    ' Zoom value in percent

    ActiveWindow.Zoom = 100

 

I know that there is another one that forces Excel to Maximise too.

 

Cheers,

Gary

 

Gary Voltz
SASTO4

Test Equipment and Maintenance and Calibration Centre

Facilities Management Services

Technology and Asset Services

Airservices Australia


E-mail: gary.voltz@airservicesaustralia.com

  _____  

Airservices Australia
Ph 1300 301 120       (within Australia)
Ph +61 7 3866 3382  (outside Australia) 
Fax +61 7 3866 3531
HYPERLINK "http://www.airservicesaustralia.com/"www.airservicesaustralia.com

CAUTION: This e-mail is confidential. If you are not the intended
recipient, you must not disclose or use the information contained
in it. If you have received this e-mail in error, please tell us
immediately by return e-mail and delete the document.

Airservices Australia does not represent, warrant or guarantee
that the integrity of this communication is free of errors, virus
or interference.

 

  _____  

From: Amrik Sekhon [mailto:Amrik@GeePlus.Biz]
Sent: Tuesday, 16 September 2008 10:17 PM
To: VRF
Subject: [vrf] Charts in Excel not visible

 

Hi All

 

When i create a chart in excel as a new sheet it is not visible or sometimes it is fomatted so that only the title is visible at about 30pt font size. I have tried to resize using drag of the mouse as well as the options in the view menu on the toolbar. However if i create the chart as an object on the sheet the formating is fine,alas i prefer not to do this since i have 6 graphs to display and i would prefer to have them as individual sheets.

 

I have a series of data points and i use macros in excel to create the charts. On my laptop they work fine and the formating is correct but on the test machine they are all messed up. I have attached pics of how the chart should look like (good) and bad charts for XL 03/07 as generated by my test machine.

 

I am using win XP SP2, I have tried using XL2003 and 2007 with differing results. I have tried this on 3 different machines and only one is problematic which also happens to be the main test machine, doh.

 

I have searched the archive and there is no info on this, so any pointers or help appreciated.

 

I can send my XL file to anyone should they require it.

 

Cheers

 

Amrik

 

 

 

 

 

 


---
You are currently subscribed to vrf as: gary.voltz@airservicesaustralia.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".


---
You are currently subscribed to vrf as: hua_jing@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes