+ Reply to Thread
Results 1 to 2 of 2

Expand a table on a protected sheet

  1. #1
    Forum Contributor
    Join Date
    04-15-2008
    Location
    Texas, USA
    MS-Off Ver
    M365 Excel Version 2210
    Posts
    216

    Expand a table on a protected sheet

    I have a table that I want my users to be able to expand to the right with new data, if needed. This table is on a sheet that I need to protect. When the sheet is unprotected and I enter data to the right of the table, the table properly expands to encompass the newly entered data. If I unlock the cells to the right of the table then protect the sheet, I can enter the new data to the right of the table, but the table doesn't expand to right. How do I fix this problem?

    Thanks
    RR

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,791

    Re: Expand a table on a protected sheet

    If the sheet is protected, then the table will not expand. You have a choice, unprotect the sheet & allow the table to expand, or protect the sheet & accept that the table will not expand.

+ 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. Protected table auto expand and auto formulas
    By benoj2005 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2022, 10:20 AM
  2. [SOLVED] Auto expand table when sheet is protected
    By Undo in forum Excel General
    Replies: 2
    Last Post: 03-21-2022, 07:53 AM
  3. Replies: 0
    Last Post: 05-21-2020, 07:36 AM
  4. +/- Expand-Collapse button on Protected sheet
    By yendordf in forum Excel General
    Replies: 1
    Last Post: 03-09-2020, 06:32 PM
  5. [SOLVED] Allow Table to Expand on Protected Sheet
    By crazyforexcel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2019, 02:32 PM
  6. Expand table rows in protected sheet (2)
    By Probe123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2019, 04:20 AM
  7. [SOLVED] Expand table rows in protected sheet
    By pezalmendra in forum Excel General
    Replies: 3
    Last Post: 04-14-2014, 12:31 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