Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Consecutive No'ing WHEN ADDING/DELETING ROWS | Excel Discussion (Misc queries) | |||
Adding and deleting rows with formulas ****Need Help**** | Excel Discussion (Misc queries) | |||
Sequential number - adding and deleting rows | Excel Discussion (Misc queries) | |||
Disable Adding & Deleting Rows/Columns | Excel Discussion (Misc queries) | |||
Disable Adding or Deleting Rows and Columns | Excel Discussion (Misc queries) |