Prevent user from modifying first row

Hi,

I'm trying to prevent the user from playing with A1:AB1. I've tried protecting that range but it's seems like a hassle to unprotect when macro runs/protect when macros ends and protect first time user opens the workbook.

I've opted for the Worksheet_SelectionChange option which is fine by me however I run into a problem when user selects a column or the entire sheet.

Please Login or Register  to view this content.

I understand I can't offset the row in these situations but I can't find the code to modify it. Say offset by one row when users selects column but let the user select the whole sheet. Any ideas ?

Thanks,
amphi