Hi guy's,

I have a workbook with lots of different sheets in it. In all of the sheets that I want people to be able to input information I have data validation, and sheet protection in place so people can only enter certain information...

I have one sheet where i have SHAPES used as hyperlinks that i need people to move around feely across the sheet. I have 'unlocked the shapes' so when i lock the sheet, people can still move and play with them, but they can also DELETE them! (not very helpful as they are also hyperlinks!) I was wondering if there is an application.Onkey where i can disable the use of "{delete}" and "{backspace}" for this sheet only, and as soon as I the click on another sheet, the function to delete becomes availbe again? Then disabled when they click back on the sheet? etc. etc.

They don't need to enter any information on the sheet I want to disable the delete function on, it's just a results viewing page so it doesn't matter about then not being able to delete things if they mess up!

any help would be fantastic,

thanks alot

Thomas