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 cell security

Hi,

Is there anyway that I can stop a user adding any other value than a number,
I have put in place validation but the users can still add their own formula,
eg =sum(A1:A4)

This causes a problem as if the have added a value incorrectly into one of
the 'summed' fields it is hard to locate the error!

Thanks in advance for your help.

Steve

 
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
Cell Security richarmk Excel Discussion (Misc queries) 1 June 12th 07 02:14 PM
Worksheet Security/Cell Protection MLK Excel Worksheet Functions 2 March 8th 07 10:47 AM
show macro security setting in a cell Mark Excel Worksheet Functions 3 March 21st 05 07:53 AM
Cell Security not maintained Greg Excel Discussion (Misc queries) 1 February 17th 05 06:26 PM
Security... LC[_2_] Excel Programming 2 December 22nd 03 05:05 PM


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