Thanks Frank,


Out of curiosity
Other then in another sub, is there any way I could have accidentall
switched off events? I've had a look at the other subs in the sheet
and can't see where the events cold have been swithced off withou
being switched on again?

Thanks

Will



you have probably disabled the application.enablevents. To
enable them again put the following line in the Immediate
window and execute this line:
Application.EnableEvents = Tru

--
Message posted from http://www.ExcelForum.com