+ Reply to Thread
Results 1 to 2 of 2

Sheet Protection and Inserting Comments, Rows, Columns problem

  1. #1
    Forum Contributor
    Join Date
    10-22-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    162

    Sheet Protection and Inserting Comments, Rows, Columns problem

    Hi,

    I'm not sure if I have a bit of a dodgy workbook here but the sheet protection code isn't working as expected.

    I have a worksheet that contains a table of data. The cells within this table are unlocked but the headings and everything else is around it is locked.

    I need to protect the sheet to prevent the user entering data outside of this table, no problem.

    Please Login or Register  to view this content.
    I need to allow the user to be able to use the AutoFilter, no problem.

    Please Login or Register  to view this content.
    I need to allow the user the ability to insert comments, problems start here:

    Please Login or Register  to view this content.
    With the sheet protection set like this I can now insert and delete rows, columns and indiviual cells. I can't seem to get it locked down right to allow comments but not inserting / deleting cells/columns/rows. I've even tried:

    Please Login or Register  to view this content.
    But no change. Anyone else any experience with this???

    Thanks, TC

  2. #2
    Forum Contributor
    Join Date
    10-22-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    162

    Re: Sheet Protection and Inserting Comments, Rows, Columns problem

    Presuming it must have been having a moment as it now works fine!

+ 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] Problem inserting rows on filtered sheet
    By beng404 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2013, 10:16 AM
  2. VBA Protection Problem w Grouping and Cell comments
    By fmaa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-22-2013, 11:03 AM
  3. Inserting rows and columns in protected sheet.
    By anulas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-26-2007, 02:40 AM
  4. [SOLVED] protection and inserting rows
    By tee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  5. protection and inserting rows
    By tee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10: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