Macro pulling & copying data from a very hidden worksheet

Not sure what you mean but is my edited version ok?

Originally Posted by backyardfun

works perfectly until I hide the worksheet "template".

Not sure if you meant it works fine until the point you want to hide the worksheet, or did the macro not work at all after you hide it.

If it's working fine, add this line to very hide it.

Please Login or Register  to view this content.

It works fine until I hide it which is what I want to do. How can hide it and have the macro work?

I don't think there's a need to make the sheet visible first for the macro to work. You can just set the sheet to very hidden through VBA editor. Press F4 to bring up the properties window, choose the worksheet ("Template") and look for the Visible property, and set it to very hidden.

You can't select on a hidden sheet. However, you're in luck. The code can be modified to do the same thing without Select. I have compiled but not tested this.

Please Login or Register  to view this content.

Perfect. Thanks a million!

You're very welcome! If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved.

Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."