Restrict the user from ADDING/DELETING column/rows

  • Thread starter Thread starter cskgg
  • Start date Start date
C

cskgg

Hiya all,

Firstly, my sincere congratulations and gratitude to the makers of thi
forum - it is cool.

Does any one now how to restrict the user from ADDING/DELETIN
ROWS/COLUMNS. Whenever the user tries to add/del columns or rows,
want the system to prompt the user that he cannot do so.

Thank you.
Kind regards
cskg
 
You need to use Tools/Protection/Protect sheet, when the menu items to
perform those actions is unavailable.

You can allow cells to be changed by formatting some or all as unlocked
beforehand.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to modify a macro for deleting rows based on two or more colu 3
Delete Rows 5
Speeding up a delete rows Macro 6
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2
Delete Columns Macro 12
How to add a PivotItem ? 2
Adding Several Rows at a time and Asking for User Input 2
Deleting rows triggers the macro :( 1

Back
Top