+ Reply to Thread
Results 1 to 2 of 2

Not able to insert cell on unlocked column of protected worksheet

  1. #1
    Registered User
    Join Date
    10-20-2015
    Location
    Columbus, Ohio
    MS-Off Ver
    2010
    Posts
    1

    Not able to insert cell on unlocked column of protected worksheet

    I have created a spreadsheet used to schedule a television channel. The spreadsheet contains 8 pages, one for each day of the week and one for the current programming database. Since the weekday sheets contain vlookup, etc. links to the database sheet and the sheet column width and spacing is critical, I need to keep these sheets protected. I have one column on each weekday sheet that I have unlocked for programming entry. The issue is, I need to be able to insert a cell (shift cells down), but cannot do so on a protected sheet even though this column is unlocked. Since people very unfamiliar with Excel will be using this, I do not want them to unprotect and protect in order to insert. Thanks for any help or suggestions.

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,077

    Re: Not able to insert cell on unlocked column of protected worksheet

    Please attach a sample of your workbook so we can test solutions using your own data. Remember to remove/replace any sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Replies: 2
    Last Post: 05-27-2015, 02:13 AM
  2. Don't select any cell on protected worksheet with unlocked cells
    By L.Overes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 03:22 AM
  3. Replies: 1
    Last Post: 03-07-2009, 03:42 AM
  4. Htperlink in an unlocked cell but protected worksheet
    By ywc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2006, 08:50 PM
  5. How do I insert a comment in unlocked cell of a protected workshee
    By TD_Anne in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2006, 03:30 PM
  6. Replies: 3
    Last Post: 12-16-2005, 04:10 PM
  7. Replies: 1
    Last Post: 06-16-2005, 07:05 PM

Tags for this Thread

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