autorun upon activating a sheet
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 |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com