ON HIDING SHEETS

Posted by RANDY on September 12, 2001 7:41 AM

IF I HIDE A SHEET CAN A MACRO STILL REFRENCE THAT SHEET OR DOES THE MACRO NEED TO UNHIDE IT THEN REHIDE IT? ONE MORE THING ...HOW DO STOP THAT ANOYING FLICKERING WHEN RUNNING A MACRO THAT SWITCHS THRU MULTIPLE SHEETS

Posted by Andrew Cheung on September 12, 2001 7:47 AM

You can still run your macro even if the sheet is hidden,
To avoid seeing the marco from running.
Add the code below to your macro in the beginning:
application.screenupdating = false 'no screen update is seen

In the end of you code, add the following to re-activate the screen updating
application.screenupdating = true

Posted by RANDY on September 12, 2001 7:59 AM

SCREEN FLICKER IS GONE..THANKS

Posted by RANDY on September 12, 2001 8:05 AM

I HAVE TRIED HIDING AND RUNNING MY MACROS, BUT I END UP WITH "SELECT METHOD OF WORKSHEET CLASS FAILDED"

Sheets("WORKSHEET").Select

'"WORKSHEET" IS HIDDEN'