Cell protection best practice?

G

gidsy

Board Regular
Joined
Jan 13, 2005
Messages
142
Hi,

I have a workbook with multiple sheets. I want to protect some of the cells in some of the sheets.

I want the user to be able to insert rows and columns without the protection coming off.

Can you give me some advice on the best way/s of doing this...

We are currently using excel 2003 but will be moving to 2007 shortly...

TIA...
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
You must log in or register to reply here.

Similar threads

H
  • Question Question
VBA to protect/unprotect sheet...
Replies
6
Views
248
jkpieterse
jkpieterse
A
  • Solved
excel protected sheet - some cells are unlocked for user input getting cleared on click
Replies
3
Views
131
AgentBaadal
A
M
  • Question Question
Protecting Sheet from users but permitting Power Automate
Replies
1
Views
516
ExcelToDAX
E
FloatedWheat
  • Question Question
Protect Sheet with Different User Permissions
Replies
3
Views
557
iggydarsa
iggydarsa
H
  • Solved
Copy/Move Data from a table to another Sheet to a table
Replies
2
Views
355
himaruasuka
H

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

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