Paste text into a locked or hidden cell

S

sparx

Is there any vba that will let you paste information into a cell that i
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 th
cell is locked and dont want the cell typed directly into
 
C

Chip Pearson

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" <[email protected]>
wrote in message
news:[email protected]...
 
Top