+ Reply to Thread
Results 1 to 2 of 2

select unprotected cells

  1. #1
    Registered User
    Join Date
    06-24-2015
    Location
    Johannesburg
    MS-Off Ver
    2013
    Posts
    43

    select unprotected cells

    Hello Chaps

    I used to use supercalc and it had a very nice feature which i cant find in excel

    selected cells could be protected same as in excel

    while these cells remained protected the whole work sheet could be selected and the
    "selection pane" would cover the protected cells but not allow them to be edditted.

    The advantage of this was that when all cells ( except protected cells)needed to be cleared
    then it was easy to select the whole worksheet and press "delete" . all unprotected cells
    would be deleted and the protected cells would be left unchanged. This was an easy way of
    leaving all formula intact when copying the worksheet.
    can excel do something similar?
    regards

    fred

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: select unprotected cells

    I would imagine you are stuck using VBA for this.

    http://spreadsheetpage.com/index.php...nlocked_cells/
    https://www.extendoffice.com/documen...ked-cells.html

    Please Login or Register  to view this content.

    If you wanted to use it frequently across multiple workbooks you could save it in your personal VBA or you could just insert it into one workbook module so it is available for that workbook only.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

+ 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. [SOLVED] Select Next Unprotected Cell of Protected Sheet
    By walkerj1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2012, 04:12 PM
  2. protect sheet, not move after enter, select unprotected cells only
    By Peto in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2009, 05:05 PM
  3. Replies: 1
    Last Post: 05-07-2009, 11:49 AM
  4. [SOLVED] Highlight UNPROTECTED cells
    By ahanmagey in forum Excel General
    Replies: 3
    Last Post: 10-11-2008, 09:15 AM
  5. How To Save Just Unprotected Cells
    By PeteC in forum Excel General
    Replies: 0
    Last Post: 08-08-2008, 11:27 AM
  6. [SOLVED] tab between unprotected cells
    By LesaT in forum Excel General
    Replies: 1
    Last Post: 11-03-2005, 07:35 PM
  7. Unprotected cells
    By TonyV in forum Excel General
    Replies: 2
    Last Post: 01-12-2005, 11:20 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