Hi Russ,

The procedure operates on the active workbook.

If you have a lot of workbooks that are subject to this problem, you could
assign the maceo to a custom toolbar button.

Alternatively, you could wrap the macro in a loop to run on (say) all
workbooks in a designated folder.


---
Regards,
Norman



"ChAnDeRu" wrote in message
...
Norman,

Where do I enter this script? Does it need to go on each spreadsheet or
run
only once for it to work?

Thanks
Russ
--
NAG - Network Administrator Guru 8-)


"Norman Jones" wrote:

Hi ChAnDeRu,

See the following post by Jim Rech:

http://tinyurl.com/auoyb


---
Regards,
Norman