Results 1 to 7 of 7

Locking all Formulas on a spreadsheet

Threaded View

Satanscat Locking all Formulas on a... 01-29-2010, 04:25 PM
JBeaucaire Re: Hi and please help! 01-29-2010, 04:47 PM
Satanscat Re: Locking all Formulas on a... 01-30-2010, 04:56 AM
contaminated Re: Locking all Formulas on a... 01-30-2010, 05:02 AM
JBeaucaire Re: Locking all Formulas on a... 01-30-2010, 05:57 AM
Satanscat Re: Locking all Formulas on a... 01-30-2010, 01:11 PM
JBeaucaire Re: Locking all Formulas on a... 01-30-2010, 01:15 PM
  1. #1
    Registered User
    Join Date
    01-29-2010
    Location
    Staffordshire
    MS-Off Ver
    Excel 2003
    Posts
    3

    Exclamation Locking all Formulas on a spreadsheet

    Hi All,

    I am currently working on a new spreadsheet for my company in which the workbook has various TABS for each department in which data is entered and formulas are in place to calculate totals on a daily, weekly and monthly basis.

    On top of this I have other TABS showing the STATS for all departments for weekly monthly and annual figures.

    All the TABS in the workbook contain at least 1 if not numerous formulas, and in fact the Stats tabs are only for pulling data from the other sheets.

    I understand you can unlock cell ranges for data entry and lock other cells but I can only see this in "ranges".

    What I would like to do is protect every formula on the workbook as they are so extensive it would take me as much time to protect each/give access to certain ranges as it did to create the workbook in the first place!

    Can anyone tell me if this is possible, or am I best to lock the whole workbook and only allow permissions to certain people within each department?

    Thanks all!!

    ~Sat~
    Last edited by Satanscat; 01-30-2010 at 04:54 AM. Reason: Incorrect title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1