Restrict the user from ADDING/DELETING column/rows

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
 
B

BrianB

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