Sorting a table in a protected sheet when some cells are locked
Jan 30, 2015 · Step 1: Make cells editable so that sorting will work. Add cells we want to sort to a range and make that range editable in “Allow Users to Edit Ranges.” This allows users to edit …
How to protect a column in an Excel Table | MrExcel Message Board
Jun 24, 2013 · I need to protect some columns with formulas in an Excel Table. Is there any way I can do this without using a macro. The moment I convert my data to a table the protection …
Protect Some Columns but Allow Dynamic Table - MrExcel
Aug 19, 2010 · Can anyone kindly tell me how I can protect some columns of a dynamic table but still allow users to create new rows and formula in the locked columns are carried down.
VBA to Lock Multiple columns | MrExcel Message Board
Feb 21, 2011 · Hi All, I'm stuck on a multiple lock macro that i'm hoping you can help me with I have a worksheet where I need to lock multiple columns before I protect...
How to allow "column width change only" in a protected sheet
Apr 28, 2018 · Hello, In one of my protected sheets (only two options checked in protect dialog: "select locked cells" and "select unlocked cells"), I want to allow the users to only be able to …
Can I Protect Sheet but still be able to hide rows/columns?
Jan 11, 2012 · Hi everyone I am using Excel 2010. I am looking to protect Cells within a worksheet but for users to be still able to hide Rows and Columns with protected cells in …
Prevent people from hiding cells in Excel | MrExcel Message Board
Feb 3, 2020 · I have a spreadsheet I need to share and allow people to edit - However I need them to stop hiding cells as it is causing big problems later on as not everyone knows how to …
how to insert rows along with formula in protected sheet
Oct 11, 2012 · Hi itis, this one was a little challenging First thing that needs to happen is to set the protect sheet options: allow users to select locked cells, select unlocked cells, insert rows. …
Protect cells but still allow hide / unhide grouped columns?
May 15, 2015 · Hey guys. I have a protected worksheet so that people in my office do not break some hidden formulas. There are three columns on the sheet that we want to be able to hide …
Prevent a specific column from editing in a Table - MrExcel
Aug 21, 2020 · I am probably looking a VBA code to protect just one column from editing or changing data in it. I have a Table - Table1 in my macro-enabled file: Users should be able to …