Restrict the user from ADDING/DELETING column/rows
 

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

--
Message posted from http://www.ExcelForum.com

Restrict the user from ADDING/DELETING column/rows
 

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.


---
Message posted from http://www.ExcelForum.com/