Excell 2007 Copy Workbook

[Grumpy9215]

Is it possible to copy a work book?

I have 2 worksheets, one is for the end user to use, the second sheet is hidden and contains the data table for various look up tables and validation lists.

[Richard Buttrey]

Hi,

Yes of course it's possible to copy a workbook.

If behind your question is the desire to keep the second sheet hidden even when it is copied or used by someone else, then in the Visual Basic Environment (VBE), set the Visible property of the sheet to be xlVeryHidden. This will prevent it being unhidden from Excel itself. To prevent someone going into the VBE and unhiding it, password protect the VBE.

HTH