Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overtype mode
Cool,
1) Lock the cells that you don't want overwritten 2) Protect the sheet. OR 1)Protect the sheet, with blank cells unlocked and 2) use this change event code to lock any cells that were blank but are no longer blank Private Sub Worksheet_Change(ByVal Target As Range) Me.Unprotect Target.Locked = True Me.Protect End Sub Copy the code, right-click the sheet tab, select "View Code" and paste the code into the window that appears. Set the blank cells to unlocked (under format, protection tab) and protect the sheet with no password. (You can add a password if you want....) HTH, Bernie MS Excel MVP "coolwolf590" wrote in message ... Can you permanently disable overtype mode in an Excel 2003 spreadsheet? I have designed a spreadsheet and it is vital that when a cell is clicked upon, the cell does not overtype. I know that you can press F2 or double click, but need the cell or sheet to do this automatically. Possibly a macro or Vb command? I'm not an expert but am an MCP. -- CW590 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MODE calc where more than one mode number! | New Users to Excel | |||
Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |