Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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/

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Consecutive No'ing WHEN ADDING/DELETING ROWS CMack Excel Discussion (Misc queries) 2 January 17th 08 03:08 PM
Adding and deleting rows with formulas ****Need Help**** [email protected] Excel Discussion (Misc queries) 5 May 31st 06 05:42 PM
Sequential number - adding and deleting rows Suzan Excel Discussion (Misc queries) 2 January 4th 06 09:36 PM
Disable Adding & Deleting Rows/Columns Playa Excel Discussion (Misc queries) 1 February 3rd 05 03:42 PM
Disable Adding or Deleting Rows and Columns Playa Excel Discussion (Misc queries) 1 January 10th 05 10:23 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"