Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default Lock formulas from being edited

Is there is any way to protect those formulas from being edited and in
the same keep a personel password for everysheet


No. But you could unlock the cells they need to use and keep it locked
all the time with a password they don't know. That is the typical
method.
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
Lock formulas only not data Terry Excel Worksheet Functions 5 May 24th 08 08:39 PM
lock only formulas, not worksheet ericaamousseau Excel Discussion (Misc queries) 2 January 19th 08 12:18 AM
Lock formulas in a cell [email protected] Excel Discussion (Misc queries) 6 July 26th 07 05:00 AM
Lock macro's from being edited Tinkerbell.1178 Excel Discussion (Misc queries) 1 July 13th 07 08:58 AM
how do I lock certain cells from getting edited sahishnu New Users to Excel 1 December 29th 06 01:49 PM


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