Announcement

Collapse
No announcement yet.

Edit range manually, restrict pasting in range

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Edit range manually, restrict pasting in range



    Hello,

    I have an Excel file with roughly 40 tabs that I need to be able to do the following things in:
    • Edit freely in Columns A through G
    • Write freely in Columns H to AB
    • Block all types of Pasting in Columns H to AB (there should be no copying at this would not make sense)
    • The tab named 'Master' must be completely editable
    I have tried many solutions but each one is lacking one way or another.

    The file cannot be altered in its format. It has been decided on by upper management. I have not included a file as I do not see it as being useful.

    The first one was to block all copy and pasting in certain columns. See:https://stackoverflow.com/questions/46997587/excel-vba-disable-from-pasting-specific-range-in-worksheet?noredirect=1&lq=1
    This option was not feasible as I was no longer able to write in any of the affected columns.

    Then I tried to disallow pasting in the workbook by slightly modifiying (I substituted the c for a v) the code that Tom Urtis wrote here: https://www.mrexcel.com/forum/excel-...ste-excel.html
    But then I was unable to copy and paste in Columns A to G as well.

    Then I found this great article: http://www.vbaexpress.com/forum/show...for-One-Column
    This seems to be the closest I have been able to find but am unable to modify the code as I am unfamiliar with these options.

    I have included all of my references in hopes that someone will be able to piece something together.

    Thank you very much




  • #2
    Hello,
    One way would be API ,,https://www.mrexcel.com/forum/excel-...tatus-bar.html
    If the solution helped please donate to RSPCA

    Sites worth visiting: Rabbitohs | Excel-it royUK | Excel Matters Rory | Kris' Spreadsheet Solutions | Domenic xl-central | The Smallman

    Comment


    • #3


      Hello,

      I apologize for not responding sooner. Thank you for taking the time to give me some help.

      Comment

      Working...
      X