Application.onkey, only active on specific sheets!

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

I was hoping for something along the lines of putting in the sheet viewing code;

Application.OnKey "{delete}"
Application.OnKey "{backspace}"

Then 'dissable macro once sheet has changed'??

Never mind, I've figured it out... for anyone who needs for their 'disabled key' to only work on a specific sheet, enter this into the sheet 'view code' when you right click it.

Just change the 'delete' and 'backspace' to the buttons you want to toggle on and off

pretty helpful page on the code names for buttons here too:
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

Private Sub Worksheet_Activate()
Application.OnKey "{delete}", ""
Application.OnKey "{backspace}", ""
End Sub

Private Sub Worksheet_Deactivate()
Application.OnKey "{delete}"
Application.OnKey "{backspace}"
End Sub