+ Reply to Thread
Results 1 to 1 of 1

How do I clear data from cells when protected.

  1. #1
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    160

    How do I clear data from cells when protected.

    Hi I posted something similar on here but got no answer and want to change it a bit https://www.mrexcel.com/board/thread...eeded.1170440/.

    I have a workbook that I protect and leave a few cells unlocked so people can input data. I also have the following macro that runs when people input data,

    Please Login or Register  to view this content.
    The Issue I have is im trying to just unprotect the cells that have data in that I need to delete and then clear cells but at present its unprotecting the whole sheet.

    The cells that have data in that need clearing are
    C9:C11
    F18
    G18
    B22:B33
    F36
    G36
    B40:B47
    G51
    G54
    G56
    C59.

    Workbook enclosed,

    Any Ideas?
    Attached Files Attached Files

+ 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. Clear contents in Merged and Un-Merged, Unprotected Cells of a Protected Worksheet.
    By Magnetite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2020, 04:23 AM
  2. Clear.Contents does not work when Password protected for sheet
    By chparkervatech in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-29-2016, 05:03 PM
  3. clear password protected combo
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-16-2013, 04:54 PM
  4. Replies: 3
    Last Post: 09-26-2012, 06:17 AM
  5. Excel 2007 : Clear contents on all protected sheet
    By SEHRA in forum Excel General
    Replies: 0
    Last Post: 06-22-2011, 08:36 AM
  6. Clear protected cells
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2007, 03:34 PM
  7. [SOLVED] How do I Clear ALL unprotected data entry fields in a protected sh
    By bobreese in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-17-2005, 09:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1