Thread: Slow macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johan Johan is offline
external usenet poster
 
Posts: 43
Default Slow macro


Hi, I have a macro with 5 different userforms which will help the user to get
the correct input. When I run the macro by steps (F8) the macro runs OK, but
when i run the macro by (F5) the macro slow very much down in speed.

I think the problem is the Userforms, but I am not sure. I have been using
Userform.hide and unlode Userform to see if it speeds up the macro, but
result is negative. Any one who has any sugestions?

Johan