+ Reply to Thread
Results 1 to 9 of 9

Table to Add Rows Protected Sheet

  1. #1
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Table to Add Rows Protected Sheet

    Hello,

    Is there a way to allow a table to expand rows when the sheet is protected?

    Thanks,
    Donny

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Table to Add Rows Protected Sheet

    No you must free the table to do this........
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Table to Add Rows Protected Sheet

    How to free?

  4. #4
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Table to Add Rows Protected Sheet

    First Unprotect the sheet then select the whole column which one need to free the press control 1 ->>> under the protection tab uncheck the protection then ok

    Now press Alt->H->O->P check mark in open window on insert row then put the password and confirm the password and ok.

    Hope it will help you...

  5. #5
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Table to Add Rows Protected Sheet

    Not sure how to do this can you take a look please? It is on the Entries sheet. The password to protect workbook is "bob" if needed.

    Thank you

  6. #6
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Table to Add Rows Protected Sheet

    Now tell me what do you want??? There are too many sheets and what you want ??

  7. #7
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Table to Add Rows Protected Sheet

    I would like the Entries sheet table to expand when I start to type in new row please.

  8. #8
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Table to Add Rows Protected Sheet


  9. #9
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Table to Add Rows Protected Sheet

    This does not help me thanks anyway.

+ 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] Inserting New Rows in Protected Table
    By RSa in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 02-02-2016, 04:36 AM
  2. [SOLVED] Expand table rows in protected sheet
    By pezalmendra in forum Excel General
    Replies: 3
    Last Post: 04-14-2014, 12:31 AM
  3. [SOLVED] User Cannot Add Rows to Password-Protected Table
    By snapfade in forum Excel General
    Replies: 3
    Last Post: 01-27-2014, 08:15 PM
  4. Use of Pivot Table in a Protected sheet
    By lclarke in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-19-2012, 08:44 AM
  5. Delete rows in a protected sheet with protected cells
    By Maranwe in forum Excel General
    Replies: 7
    Last Post: 10-31-2011, 08:12 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