I have two codes, one for adding rows in a locked spreadsheet.
The problem I have is that when I have deleted rows with the second VBA Code, I am not able to use the first code to add new rows. Nothing happens when I try.
Here are my two codes:
Adding row (with "On Error Resume Next" because of error 1004, where you write the number of wanted rows in cell A10 and it will copy first row and insert where mouse pointer is
This code is for deleting rows in locked cellsPlease Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks