+ Reply to Thread
Results 1 to 3 of 3

Formula on a protected cell

  1. 02-08-2023, 07:29 PM #1
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Formula on a protected cell

    Hi,
    I have this vba code but when I protected the cell F it is not working. Can someone please make it work when F cell is protected cell?

    Please Login or Register  to view this content.
    Thank you in advance.
    Reply With QuoteRegister To Reply
  2. 02-08-2023, 07:48 PM #2
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,156

    Re: Formula on a protected cell

    Either unprotect the sheet before updating column F and protecting it again afterwards.

    Or use something like this:

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-08-2023, 08:09 PM #3
    RJ1969
    RJ1969 is offline
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,812

    Re: Formula on a protected cell

    Where do you want me to put that code? Sorry I don't get it.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] When I Double Click on Cell Erase Text in the Cell , in the PROTECTED SHEET
    By soubasa in forum Excel General
    Replies: 2
    Last Post: 04-16-2020, 03:46 PM
  2. [SOLVED] Formula in Cell aint work if Sheet's are Protected
    By Henrik-Chr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-07-2019, 12:47 AM
  3. Prevent Cell Contect being changed when cell is unlocked but sheet protected
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-17-2012, 09:15 AM
  4. Pasting outside data into unlocked cell of protected sheet without the cell locking
    By DarthMinogue in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-15-2011, 09:12 PM
  5. formula by default to look at data within protected cell
    By raggatip in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 02-06-2011, 01:41 PM
  6. Automatically update a protected cell based on contents of an unprotected cell
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2009, 11:13 AM
  7. [SOLVED] a protected cell w/formula only updates only on file save?
    By snap in forum Excel General
    Replies: 2
    Last Post: 05-18-2005, 08:06 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1