Help for this page

Select Code to Download


  1. or download this
    $newworksheet->Activate();
$Excel->ActiveWindow->{DisplayGridlines} = 'False';
  2. or download this
    Selection.TickLabels.AutoScaleFont = False
With Selection.TickLabels.Font
    .Name = "Arial"
...
    .ColorIndex = xlAutomatic
    .Background = xlAutomatic
End With
  3. or download this
    $Excel->Selection->ThickLabels({AutoScaleFont => 0});
$Excel->Selection->ThickLabels({Font => {Size => 8}});