Protect Formulas but Allow Delete Row and Insert Row

S

sjkenjalo

New Member
Joined
Jun 6, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi,

I need to be able to protect formulas in cells in a column but allow the user to insert and delete rows. Is this possible??
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
You must log in or register to reply here.

Similar threads

G
  • Question
Deleting rows on a protected worksheet
Replies
7
Views
913
Alex Blakenburg
A
S
  • Question
How can you insert images on a protected worksheet in a protected workbook?
Replies
1
Views
616
spurs
S
E
  • Solved
Delete row based on whether cell in alternate column in row has data
Replies
3
Views
97
LazyBug
LazyBug
A
  • Question
Protect cell formulas in table enable insert row with auto formulas
Replies
0
Views
416
Apple08
A
T
  • Question
Insert/Delete not available on Protected Sheet
Replies
0
Views
369
tlrowe9065
T

Forum statistics

Threads
1,215,079
Messages
6,122,998
Members
449,092
Latest member
masterms

Share this page

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
Back
Top