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

Unprotect the worksheet before you update the cell, modify the
cell, and reprotect the sheet. E.g.,

ActiveSheet.Unprotect password:="whatever"
ActiveCell.FormulaR1C1 = "=getmacaddress()"

ActiveSheet.Protect password:="whatever"



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sparx"
wrote in message
...

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

Tried your method - worked very well - thanks.


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