Thanks Al,
Any reason why that code is stopping my file from opening ? If I disable Macros it opens fine, it I enbale, I see the worksheet but then xl stops responding.
The only code I have in there is in module 1, and its just the code above repeated for 30 different range names ???
Strange.
Bob