I don't know why your hidden sheet is slow to unhide but you don't need to
unhide to copy data to a hidden sheet.


Gord Dibben MS Excel MVP


On Mon, 25 Jan 2010 07:15:01 -0800, Shawn
wrote:

I need a suggestion. Employees send their timesheets via email into our
central office. We have an Employee Database created in excel. A VBA copies
and pastes the time sheet information into the Employee Database and stores
it.

There is a hidden sheet in the Employee Database that the copied information
from the Time Sheets gets copied into. I have noticed when I try to unhide
this sheet, it unhides extremely slowly. Why? Is there ghost information
being stored in this sheet that is making it large? Suggestion solution?