Insert Rows in locked table without VBA

KazTaylor

New Member
Joined
Jul 15, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Good morning everyone, first post here!

The security in our records management system is incompatible with VBA/MACROS, so I need to know if there is a solution that does not involve their use.

I have a table that contains locked columns with formulas, validated lists in others, and some others have conditional formatting.

The document is a reporting statement used by a number of clients with varying level of capability in excel, which is why I've locked the formula cells.

One client has queried about when they have an activity related to a previous one and would like to insert it directly underneath the related task to keep related work together.

I have only locked those cells that contain formulas, and I have added a picture of my current protection selections. Any advice on how this can be achieved?
 

Attachments

  • protect Sheet.PNG
    protect Sheet.PNG
    11.4 KB · Views: 6

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,956
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top