Macro dependent on hidden sheet?
I've written a Macro which returns information held in a sheet I now want to
hide (I dont want anyone messing about with the data!)
But when I hide the sheet the macro can no longer find the information and
says there is a runtime error!
Any ideas how I can get it to look up the information from this hidden sheet?
Cheers
|