LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 13
Default Lock a formula to a column of cells

I have a running balance total but as other users access this form they
inadvertently delete the formula or add more rows than have been allowed. I
can use data protection for the form but this then creates problem if they
need to add additional rows. Is there any way I can set the formula to appear
automatically in the cell such as data validation?

 
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
lock cells based on formula result MIke Excel Discussion (Misc queries) 1 October 26th 07 03:24 PM
Lock formula cells? EllenM Excel Discussion (Misc queries) 5 June 20th 07 09:04 PM
Need formula that will sum cells in a column bases on criteria in other cells. Jim Excel Worksheet Functions 3 February 18th 06 03:33 PM
How to lock a column Patty via OfficeKB.com Excel Discussion (Misc queries) 1 September 23rd 05 06:57 PM
Lock Column Shobhit Bhatnagar Excel Discussion (Misc queries) 6 May 14th 05 03:53 PM


All times are GMT +1. The time now is 04:37 PM.

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

About Us

"It's about Microsoft Excel"