T Tom Ogilvy Nov 16, 2004 #2 go to tools=>Macro=>Record a New Macro Then unprotect the sheet, (tools=>Protection=>Unprotect Worksheet) go to Tools=>Macro=>Stop Recording Do Alt+F11 find the macro you just recorded and look at the code.
go to tools=>Macro=>Record a New Macro Then unprotect the sheet, (tools=>Protection=>Unprotect Worksheet) go to Tools=>Macro=>Stop Recording Do Alt+F11 find the macro you just recorded and look at the code.