+ Reply to Thread
Results 1 to 2 of 2

How to protect excel sheet and formulas

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2013
    Posts
    7
    How to protect excel sheet and formulas
    Last edited by vivek_vx; 10-22-2013 at 08:04 AM.

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    11,469

    Re: How to protect excel sheet and formulas

    Cross post http://www.excelguru.ca/forums/showt...-and-formulas&
    http://www.vbaexpress.com/forum/show...t-and-formulas
    Be very, very careful using IFERROR ! It hides ALL errors which is not always what you want to get correct results

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Edit existing marco to unlock protect sheet, remove set criteria and re protect sheet
    By summer2010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2013, 09:29 AM
  2. [SOLVED] Found A Great VBA Script To Hide Formulas Without Protect Sheet But Still Buggy..
    By resshin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2013, 11:11 AM
  3. Sheet corrupted after using Protect Sheet with Hidden formulas
    By glk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-14-2006, 10:00 AM
  4. [SOLVED] How do I protect only formulas in Excel?
    By RHmcse2003 in forum Excel General
    Replies: 17
    Last Post: 06-21-2005, 02:05 PM
  5. Replies: 1
    Last Post: 04-08-2005, 02:06 PM

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