I have a hidden worksheet.
I try to use the data on it with a macro but it will not allow me. So i
unhid the sheet in the macro and when it finished the task i hid it back.

The problem is that I am able to see the sheet while i run the macro.
There are two solutions: 1. How can i operate a macro on a hidden sheet?
2. How can i run a macro in the background?

Please help.
Jared