Call Worksheet_Activate Event from procedure possible?

[ShieBoon]

Hi guys, is it possible to call a Worksheet's activate event from a procedure? Or maybe, refresh a worksheet from a procedure. i'm using excel 2003.

Thanks
Shie Boon

 

[RoryA]

No, I mean remove the code from the Activate event, put it in a procedure in a normal module and then call that from both the activate event and your code above. That way there is no need to actually activate the sheet to run the code.

 

[ShieBoon]

Oooohhh i see alright. I understand now. Wow u guys can really see the big picture here. Anw, i can't do that although it'll save me a few lines of codes. Cuz i've a code that sets NextRecord back to 0 to solve some deletion problems. I put this code in the Deactivate event of the MasterList worksheet. So... now i need a code to really 'REACTIVATE' the MasterList. And then i'll place that in the 'Insert New Record' procedure. haha..

 

[ShieBoon]

Oh wait maybe i can set NextRecord to 0 before the procedure. I think that'll work!

 

[ShieBoon]

It worked!! :D

 

[ShieBoon]

Alright rorya, sorry for the spam. Anw, got a qn fer ya. Could you explain to me how screenupdating works and where should i put it in my codes? I heard it helps to reduce load time.

Thanks!

 

[RoryA]

IT's OK - you weren't the spammer!

Screenupdating prevents Excel from redrawing the activewindow as your code makes changes. Not having to do that usually reduces the run time of your code.

 

[ShieBoon]

I seee. Alright, thank you very much!