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.
Last edited by goodwinh; 08-15-2011 at 12:26 PM.
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.
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
thanks for the tip Mordred.
Hi,
Maybe This will help?
Please Login or Register to view this content.
Thank You, Mike
Some Helpful Hints:
1. New members please read & follow the Forum Rules
2. Use Code Tags...Place[code]Before the first line and[/code] After the last line.
3. If you are pleased with a solution mark your post SOLVED.
4. Thank those who have help you by clicking the scales at the top right of the post.
Here...
Why don't you create a proper template workbook?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks