+ Reply to Thread
Results 1 to 4 of 4

Macro causes repair for protection

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    Nevada, USA
    MS-Off Ver
    Excel 2016
    Posts
    2

    Macro causes repair for protection

    I am making a workbook that has a table on one sheet for reviewing worker trainig data. I am now making a sheet to graphically show particular workers in a chart.

    To achieve the type of filtered table needed for the chart this code is using Advanced Filtering to take some columns and start building them on a separate sheet. There I will continue to process more things needed for the chart to work, but the RefreshChartData is causing some weird buildup that makes the sheet need repair that is always fixed with "Removed records: Protection" for the sheet where the data is getting copied to. It seems to break after using the macro abour 4 times. I tried taking out the ClearClipboard, but it still breaks. I tested clicking at a much slower frequency and even saved in between each click, reopened, and repeat until around the 4th time it needs repair on opening.

    Any help is greatly appreciated

    Please Login or Register  to view this content.
    Last edited by Bushwhacker; 04-06-2021 at 02:18 PM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Macro causes repair for protection

    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 [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] 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
    Rory

  3. #3
    Registered User
    Join Date
    04-06-2021
    Location
    Nevada, USA
    MS-Off Ver
    Excel 2016
    Posts
    2
    Sorry I fixed it. Thank you

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: Macro causes repair for protection

    Thanks.

    I can't see anything in there to do with protection?

+ 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. Repair a macro
    By Potholes in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2019, 03:03 AM
  2. Excel 2010 - Copying sheet with protection manually, protection stays... not with VBA
    By AdamParker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-02-2012, 12:38 PM
  3. Protection and Macro
    By Ritzo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2010, 07:36 AM
  4. Protection Macro
    By Loisw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2009, 04:01 AM
  5. macro protection
    By superkopite in forum Excel General
    Replies: 1
    Last Post: 04-06-2009, 06:28 PM
  6. Macro Protection
    By fodman in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 06-24-2006, 05:10 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