LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Protect cells IF the cell is not empty

Planning to make this excel file in which users should be able to fill in new
data in empty cells but not in cells that have data in them already.

I.e. IF Cell is empty, the user is allowed to fill in data. IF Cell is not
empty, cell is protected.

This way the users can only add new data to the chart but not modify old data.

thanks in advance

 
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
sum of cells until reach empty cell phsdave Excel Worksheet Functions 4 January 24th 10 11:15 AM
count non empty cells if other cell has certain value Nico Excel Discussion (Misc queries) 5 May 18th 06 10:40 AM
protect cells based on another cell Neil Excel Worksheet Functions 6 August 9th 05 03:13 PM
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? Steven Rosenberg Excel Programming 0 August 5th 03 06:10 AM
VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? SROSENYC Excel Programming 1 August 5th 03 04:34 AM


All times are GMT +1. The time now is 04:57 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"