software

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

' Keyboard Shortcut: Ctrl Shift Z
'
Sheets(quot;Accessquot;).Select
Range(quot;E9:P9quot;).Select
ActiveCell.FormulaR1C1 = quot;=getmacaddress()quot;
Range(quot;E10quot;).Select
End Sub

My worksheet quot;Accessquot; 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: www.excelforum.com/member.php...oamp;userid=16787
View this thread: www.excelforum.com/showthread...hreadid=523926Unprotect the worksheet before you update the cell, modify the
cell, and reprotect the sheet. E.g.,

ActiveSheet.Unprotect password:=quot;whateverquot;
ActiveCell.FormulaR1C1 = quot;=getmacaddress()quot;

ActiveSheet.Protect password:=quot;whateverquot;
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.comquot;sparxquot; gt;
wrote in message
...
gt;
gt; Is there any vba that will let you paste information into a
gt; cell that is
gt; locked.
gt;
gt; ' Keyboard Shortcut: Ctrl Shift Z
gt; '
gt; Sheets(quot;Accessquot;).Select
gt; Range(quot;E9:P9quot;).Select
gt; ActiveCell.FormulaR1C1 = quot;=getmacaddress()quot;
gt; Range(quot;E10quot;).Select
gt; End Sub
gt;
gt; My worksheet quot;Accessquot; has an area where you type in text (
gt; getmacaddress )
gt; into an unlocked cell - no problems but I only want to do this
gt; when the
gt; cell is locked and dont want the cell typed directly into.
gt;
gt;
gt; --
gt; sparx
gt; ------------------------------------------------------------------------
gt; sparx's Profile:
gt; www.excelforum.com/member.php...oamp;userid=16787
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=523926
gt;

Tried your method - worked very well - thanks.--
sparx
------------------------------------------------------------------------
sparx's Profile: www.excelforum.com/member.php...oamp;userid=16787
View this thread: www.excelforum.com/showthread...hreadid=523926