i knew it was something like that....but how do you relate that macro t
just that one worksheet?

for short and pretty purposes....i need a macro, on a protected sheet
in the workbook, to unprotect itself...run an autofilter and protec
itself again everytime somebody clicks on that peticular tab....

i just dont know the code to make that macro activate when just tha
one sheet is activated.

im sure its along the lines worksheet.activate ..... like you said....
just dont know what to do from there.

i can code the autofilter and all the rest of the mumbo jumbo....jus
not that....thanx if your able to help

--
cdd
-----------------------------------------------------------------------
cdde's Profile: http://www.excelforum.com/member.php...fo&userid=1553
View this thread: http://www.excelforum.com/showthread.php?threadid=27713