unhide sheet, copy data, hide sheet - screenupdate = false

Hi everyone,

I am stuck a little with something I just can't find the solution to in this forum.
I would like to:

1.) unhide a worksheet ("HELPERSHEET" in an open (and saved) workbook
2.) select a range from A3 to A62
3.) Copy the data in this range
4.) Paste this data into a .bat file
5.) Hide the "HELPERSHEET" work sheet
6.) Run the batch file.

In all of this I would not like the user to see that a workbook is being unhidden, so they don't start fiddling around with it. (screenupdate = false?).

This is what I have so far:

Please Login or Register  to view this content.

I am actually quite proud of what I got so far, and it works just perfect when run from the active work sheet, where my data used to reside prior to me wanting to hide it.

Any ideas? Do you need any further information?

Thanks a million,

Titus

Hi, I saw that quite a few of you have viewed this post. Unfortunately nobody has responded yet.. Please let me know if there is a problem in understanding my request and I will be please to elaborate.

Thanks so much to you all!
Titus.

Wow, this must either interest nobody or be really tough.. I have never received 0 responses in this forum ;-)

If you think you can help but have questions, please do contact me!
Thanks, Titus