Thanks Gord,

It looks like everything's worked except I need the protection (when
re-enabled by the macro) to still allow the use of autofilters. I have
them setup at the header row. Can you advise whether this can be
coded?

Also in the macro coding you have the questions:

'more code here to deal with "Blown Bulbs"? and
'Selection.AutoFilter to turn off Filter?

What do you mean by this?

Sorry mate. This is all a big learning process for me. I really
appreciate your help and advice.

Cheers
Damian


--
damiand_1982
------------------------------------------------------------------------
damiand_1982's Profile: http://www.excelforum.com/member.php...o&userid=37461
View this thread: http://www.excelforum.com/showthread...hreadid=571224