Results 1 to 8 of 8

Code to disable fill handle and cell drag & drop for specific worksheet only

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-25-2019
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Microsoft 365
    Posts
    178

    Code to disable fill handle and cell drag & drop for specific worksheet only

    I have a worksheet (M1) that has an excel table where the user is able to enter data. I have another worksheet (Sheet1) that extracts data from this excel table. However, I discovered that if the user decides to use the table's fill handle on one of row cells to drag down a row as a way to auto populate a new date, the Sheet1 worksheet does not recognize this new row. Instead, it loses the row it once had with formulas.

    I am thinking that there may be a macro (or maybe a formula?) to do one of either two things:

    A. Disable the fill handle and cell drag & drop feature, but ONLY for the M1 worksheet, not for the other worksheets that might be in the workbook. This way, the user is forced to manually type in the date instead of trying to drag down a new date.

    B. Enable Sheet1 to recognize the new M1 row insert and not lose any of the rows with formulas.

    Are there any such solutions? I'd be very grateful if there is. I've already spent days writing up sheets that read from excel table entries and would hate to drop this project because of this problem.

    Please see the attached file and the MS word screenshot for further reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to disable drag auto-fill, but allow drag shift-entire-row?
    By superlative in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2019, 06:13 PM
  2. How to Control Drag and Drop? (force "shift" drag-drop, disable into certain rows)
    By superlative in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2019, 11:16 AM
  3. Replies: 1
    Last Post: 11-03-2018, 04:26 PM
  4. [SOLVED] Disable fill-handle-drag-and-drop via VBA
    By MarmaladeLover in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-26-2015, 07:10 AM
  5. Replies: 1
    Last Post: 07-06-2010, 06:06 PM
  6. Disable fill handle
    By sverhaeghe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2009, 08:56 AM
  7. [SOLVED] What is keyboard shortcut equivalent to drag the fill handle
    By JZ in forum Excel General
    Replies: 2
    Last Post: 07-31-2006, 01:30 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