Create New Workbook, Copy Worksheets, But Hide One of Them - Nearly There!

[goodwinh]

Hi All,
Excel 2007
I have a 'Control' workbook which has an input worksheet and a data worksheet for each country.
By clicking a button it executes and creates a new Workbook and copies ino it that countries input worksheet and data worksheet, and places it to a file location, which is specified by a cell in the workbook.

Everything works ok, but i do not know how to hide the data worksheet in the new workbook, any ideas?

Here is my code:

Please Login or Register  to view this content.

[Mordred]

Hi goodwinh and welcome to the forum. Please take a moment to read the forum rules (located in my signature) and wrap code tags around your code as per Rule #3. Once you do that, someone will be able to help you.

[goodwinh]

thanks for the tip Mordred.

[realniceguy5000]

Hi,

Maybe This will help?

Please Login or Register  to view this content.

[royUK]

Why don't you create a proper template workbook?