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.
"NickHK" wrote:
Armando,
..PageSetup properties always seem to take an age
See if any of this helps:
http://groups.google.co.uk/group/mic...cc8762 a48cba
Watch for line wrap.
NickHK
"Armando" wrote in message
...
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.