Paste text into a locked or hidden cell
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 |
Paste text into a locked or hidden cell
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 |
Paste text into a locked or hidden cell
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 |
All times are GMT +1. The time now is 04:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com