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