Working With Hidden Sheets

You can copy from a hidden sheet the same way as with a visible sheet.

http://stackoverflow.com/questions/8...s-or-workbooks

The sheet is only hidden from view but not from code.

You can make the sheet visible just long enough to perform your code then make it hidden again. Here's a macro to copy a hidden sheet :

Please Login or Register  to view this content.

The line Application.ScreenUpdating = False prevents the user from seeing anything happening until the last line Application.ScreenUpdating = True. But, by then everything has been done
and the user only sees the results.

Hi,

There is no need to select data in order to copy it, and copying data from a hidden sheet works, unlike copying the sheet itself.

You should set the Visible property to Very Hidden an protect the VBA Project with a password.

You should also set the cells' formulae to Hidden and protect the sheet with a password. Otherwise, people will know there is a sheet even though they can't see it. And it's a simple task to write your own formula to look at other cells on that sheet.

Excel is not a secure environment!