![]() ![]() ![]() VBA code: Keep table expandable by inserting table row in a protected worksheet Dim pswStr As String In the Microsoft Visual Basic for Applications window, please copy and paste the below VBA code between the Sub and End Sub paragraphs in the Code window. In the popping up Assign Macro dialog box, click the New button.ģ. Click Developer > Insert > Button (Form Control) to insert a Form Control button into your worksheet.Ģ. Now you need to protect the worksheet to prevent the formula column from changing, but allow to expand the table by inserting new row and assign new data into the new cells. ![]() Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day!Īs below screenshot shown, a table named Table1 in your worksheet, and the last column of the table is a formula column. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |