Hi

I run Excel 2K

I have a table on a wroksheet called SUPPORT SHEET.

I use the sheet for various purposes. eg, validation tables, lookup tables etc

On a different sheet I have a macro that copies data from the SUPPORT SHEET.
The macro works fine until I hide the SUPPORT SHEET, then the macro does not
work.

Is there a way I can hide the SUPPORT SHEET but the macro I use still work?


Thanks

John