Code to save current worksheet and hidden worksheet

**fusion007** · 06-22-2011, 10:54 AM

Hi...I have this code (thanks Dom) to save the current worksheet but in the main workbook there is also a hidden worksheet which I need to save with the current worksheet workbook. This hidden worksheet must remain hidden in the new workbook as it has some calculations the user does not need to see.
The current code is

Please Login or Register  to view this content.

Can anyone please help with amending the code to save the hidden worksheet with the current worksheet? The hidden worksheet is called "calcs".

Thanks

**tigeravatar** · 06-22-2011, 10:59 AM

fusion007,

Change this line:

Please Login or Register  to view this content.

To this instead:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

**fusion007** · 06-22-2011, 11:50 AM

Hi tigeravatar...thanks for the reply
I changed the code but that still doesn't copy the hidden worksheet to the new workbook.
Any other suggestions I can try?

**tigeravatar** · 06-22-2011, 11:52 AM

fusion007,

Is the worksheet not named "calcs"? The macro simply deletes all other sheets then saves the remaining as a workbook under a different name. Also, the macro would not unhide the hidden worksheet.

~tigeravatar

**fusion007** · 06-22-2011, 12:04 PM

Hi...yes the hidden worksheet is "calcs". On the saved workbook I checked if the hidden sheet was there but there wasn't.

**tigeravatar** · 06-22-2011, 12:22 PM

fusion007,

Revamped the macro a bit, give this a try:

Please Login or Register  to view this content.

If you're still having problems, please upload the workbook with fake data so I can see what's going on

Hope that helps,
~tigeravatar

**fusion007** · 06-22-2011, 02:28 PM

Hi...that has worked fine thanks. But I have another problem now - not to do with your code though. The hidden worksheet has calculations and macros which is used to load data into a system and and is now not working.
so rather than saving the workbook is there a way that the macro I am using to copy the data is pasted into another workbook that is already saved rather than in the current workbook and then saving this worksheet as a different workbook.
I hope this makes sense.
Apologies if I should open a new thread for this.
Thanks