+ Reply to Thread
Results 1 to 2 of 2

need code to prevent pasting merged cells

Hybrid View

  1. #1
    Registered User
    Join Date
    12-08-2012
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2016
    Posts
    10

    need code to prevent pasting merged cells

    I have a range of cells that are locked but where cell formatting is enabled. Row and column formatting is disabled. And I want to programatically prevent the user from pasting a merged range (either rows, columns or both) into the protected range.

    I'm thinking I would need some king of Worksheet_BeforePaste code in the worksheet. Either that or some means of evaluating the content of the buffer.

    Thanks in advance.


    Kevin

  2. #2
    Registered User
    Join Date
    12-08-2012
    Location
    Pennsylvania
    MS-Off Ver
    Excel 2016
    Posts
    10

    Re: need code to prevent pasting merged cells

    Correction: The range receiving the paste is not locked. And the worksheet is password-protected.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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