Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 14
Default Security Settings

What is the correct security setting to allow someone to only enter data into
cells? Read & Execute or do they need Write or Modify? This is for a shared
worksheet on a global network drive; spreadsheet is accessed through a
hyperlink. Currently only Read & Execute, but users get a warning it is Read
Only. Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default Security Settings

Protect individuals cells containing formulas
--
Gary''s Student - gsnu200737


"Alex Mackenzie" wrote:

What is the correct security setting to allow someone to only enter data into
cells? Read & Execute or do they need Write or Modify? This is for a shared
worksheet on a global network drive; spreadsheet is accessed through a
hyperlink. Currently only Read & Execute, but users get a warning it is Read
Only. Thank you.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,231
Default Security Settings

"Gary''s Student" wrote...
Protect individuals cells containing formulas


Cells are locked by default. OP needs to protect WORKSHEETS.


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
security kyoshirou Excel Discussion (Misc queries) 5 July 3rd 07 06:27 AM
Security The Rook[_2_] Excel Discussion (Misc queries) 4 May 9th 07 03:12 PM
Security Settings wgaskill Setting up and Configuration of Excel 0 August 28th 06 01:34 AM
macro security settings excel change back to low john mcmichael Excel Discussion (Misc queries) 3 April 18th 06 10:43 PM
macros security settings on Excel 97? swagurl Excel Worksheet Functions 1 June 10th 05 10:39 PM


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