Onkey is an application level assignment.

Your recourse would be
- to use the Activate event of each sheet to reasign it to a sheet
specific macro.
- have one macro, but have a big case statement that determines which
action to take based on the activesheet

--
Regards,
Tom Ogilvy


"short_n_curly"
wrote in message
news:short_n_curly.1ri0eh_1120233927.4843@excelfor um-nospam.com...

ok this helps but...... if i want ctrl+r to mean the same thing on each
individual worksheet (to reset it to a default state) but each
worksheet is different e.g one worksheet will have programmed via vba,
delete cells a30:a50. and a different worksheet via a different macro
procedure will delete a1:a10, with this proposed method is it possible
to assign ctrl+r to have more than 1 dirrerent function
what i intend to ask is if i wanted event procedure to on a cell entry
to trigger a macro i will programme in that worksheet

Private Sub Worksheet_Change(ByVal Target As Range)

set target.row and column and programme in the macro

end sub

what is the private sub header for an event to trigger in that
worksheet by pressing keys ctrl+r
if i could have this i could programme a different outcome in each
worksheet using the same key entry ctrl+r and therfor users will be
able to reset each sheet back to default with the same keystrokes
hope this explains things better thanks for the replies so far


--
short_n_curly
------------------------------------------------------------------------
short_n_curly's Profile:
http://www.excelforum.com/member.php...o&userid=21576
View this thread: http://www.excelforum.com/showthread...hreadid=383876