+ Reply to Thread
Results 1 to 6 of 6

Inserting row into excel table in protected sheet

  1. #1
    Registered User
    Join Date
    01-19-2020
    Location
    Hungary
    MS-Off Ver
    Office 2007
    Posts
    19

    Inserting row into excel table in protected sheet

    Hi,

    Edit Mod : this thread is related to https://www.excelforum.com/excel-pro...ml#post5267116

    I have an excel table in a protected Excel sheet. I should be able to insert row(s) in the table but it is not possible because the sheet is protected therefore I got warning message ("The cell or chart you're trying to change is on a protected sheet. To make a change, unprotect the sheet. You might be requested to enter a password."). I set AllowInsertingRows:=True but it does not help because this an Excel table. Do you know how I can handle this by macro? I tried using the following macro but not working. Can you please help to implement this in the attached table or find another solution?


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Balazs Batta; 01-27-2020 at 04:56 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Inserting row into excel table in protected sheet

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

  3. #3
    Registered User
    Join Date
    01-19-2020
    Location
    Hungary
    MS-Off Ver
    Office 2007
    Posts
    19

    Re: Inserting row into excel table in protected sheet

    Sorry I do not know what is the problem with my post. I have put # icon . Please clear your comment.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Inserting row into excel table in protected sheet

    Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
    Just follow the instructions

  5. #5
    Registered User
    Join Date
    01-19-2020
    Location
    Hungary
    MS-Off Ver
    Office 2007
    Posts
    19

    Re: Inserting row into excel table in protected sheet

    It is done. Thank you for the instruction. The code is highlighted now.
    Last edited by Balazs Batta; 01-27-2020 at 10:44 AM.

  6. #6
    Registered User
    Join Date
    01-19-2020
    Location
    Hungary
    MS-Off Ver
    Office 2007
    Posts
    19

    Re: Inserting row into excel table in protected sheet

    Can sombody help regarding this query?

+ 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: 11
    Last Post: 01-29-2019, 09:53 PM
  2. [SOLVED] Inserting New Rows in Protected Table
    By RSa in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 02-02-2016, 04:36 AM
  3. Excel table and protected sheet
    By cameron213 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-14-2013, 12:54 AM
  4. Inserting a new row in protected sheet
    By harry$100 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-11-2013, 12:25 PM
  5. Help Inserting a row in a protected sheet using a macro
    By mrpaine in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2012, 10:30 PM
  6. Inserting in a protected sheet
    By kc27315 in forum Excel General
    Replies: 1
    Last Post: 12-18-2008, 09:10 AM
  7. Inserting Rows on a Protected Sheet
    By redstang423 in forum Excel General
    Replies: 1
    Last Post: 05-07-2008, 03:01 PM

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