Hiding Columns running slow

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone. This might sound like a real dumb question but it is my first
time using vb in excel. I created a form that allows users to hide columns by
using the checkboxes on the form. That piece of the code works fine problem
is when I format the worksheet onload it slows down the column hidding
tremendously. The format setting are as follows:

Worksheets("Report Data").Activate
ActiveSheet.PageSetup.Orientation = xlLandscape
Worksheets("Report Data").PageSetup.PaperSize = xlPaperLegal
ActiveSheet.PageSetup.PaperSize = xlPaperLegal
ActiveSheet.PageSetup.PrintGridlines = True

I am sure these settings are what are causing the slow down because when I
comment them out it begins to run fast again. I also tried each one
individually, it seems to be something with PageSetup. The code above is in
the onload of the workbook. If anybody has any suggestions I would really
appreciate it.
 
This may help some:

With Worksheets("Report Data").PageSetup
.Orientation = xlLandscape
.PaperSize = xlPaperLegal
.PrintGridlines = True
End With
 
Well I gave it a shot and it still slowed down the program. It slows it down
quite a bit. With out either pagesetup or excel4macro it runs in under a sec.
, with either on it takes around 30 to 40 secs. Well I really appreciate
everyone's help. If you still have any suggestions they are completey welcome.
 
Back
Top