![]() What I am saving for when all else fails: Inserting the table as a Document Object, which could be a workaround, * The various options for "Paste Special." The closest I got was * Formatting the Excel cells as text before pasting the data. Merging into one cell keeps the upper-left most data only. Get a warning that the selection contains multiple data values, and I triedĬonverting the table into text with manual line breaks and tab stops toĭivide columns and rows, but that didn't solve my problem.Įxcel pastes the data into several rows. The first column of the table is a list of numbers. I would like to copy a small table from Word into one cell in an Excel Sheets("Sheet1").Unprotect Password:="temp"ĪctiveSheet.EnableSelection = xlUnlockedCells ' If Not Intersect(Target, MRange) Is Nothing Then Sub Worksheet_Change(ByVal Target As Excel.Range) I think I am close, but I am getting an "End If without block If" error on the If Clause. ![]() If the user selects that cell again, they will get the usual pop-up message, "The cell or chart that you are trying to change is protected." If a user enters a date in a cell or range of cells anywhere in the column, the changed cells also need to be locked and protected (Once they enter a date, it is not allowed EVER to be changed again. ![]() I have named the cells in that column "MS96A". I have a worksheet that is locked and protected now, except for cells in a certain collumn.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |