They should be navigating and accessing the data through forms. If you do not turn if back on your users will have all kinds of problems with your db. Echo True in that sub or functions error handler to ensure that Echo is turned back on just incase there is a runtime error within that sub or function. I have a code that initially sets Screen Updating to False, but in the middle of the code it calls another subroutine and for some reason it actually shows me some (not all) actions (ie, when it selects a new sheet I get to see that). Here is a simplified version of the code Option Explicit Sub Check_Input Data() Application. Echo True*** WARNING ***If you use this, MAKE SURE you include error checking, and if you recieve ANY error,turn your screen updating back on.
It does just what it sounds like, while screen updating is turned off the screen will not show any changes that Excel executes and no new data will be displayed until screen updating is set back to true or the program ends.A recent example: My coworker uses a macro to open a sheet, searches through that sheet and activates the found cell, look at it's offset and determines if it meets criteria.If the criteria is met, then 4 arrays are filled in all using and it does this for 24 rows.This I think would give the user a bit of a fright.Thanx Kind Regards Dump the macro, convert it to VBA.