Is there any vba that will let you paste information into a cell that is
locked.

' Keyboard Shortcut: Ctrl+Shift+Z
'
Sheets("Access").Select
Range("E9:P9").Select
ActiveCell.FormulaR1C1 = "=getmacaddress()"
Range("E10").Select
End Sub

My worksheet "Access" has an area where you type in text (
getmacaddress )
into an unlocked cell - no problems but I only want to do this when the
cell is locked and dont want the cell typed directly into.


--
sparx
------------------------------------------------------------------------
sparx's Profile: http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=523926