+ Reply to Thread
Results 1 to 1 of 1

Disable fill-handle-drag-and-drop via VBA

  1. #1
    Registered User
    Join Date
    09-08-2014
    Location
    -
    MS-Off Ver
    -
    Posts
    68

    Disable fill-handle-drag-and-drop via VBA

    Greetings,
    This is somewhat in reference to my previous thread.

    The issue with this kind of thing is that Excel has built in functions which occur when you double click, alt + click etc. etc.
    Now, with the Alt + Click, the research pane comes up. I've counteracted this by temporary disabling the research pane during the course of the macro:

    Please Login or Register  to view this content.
    My issue with double click is that if someone double clicks the border of the cell, it will select the end of the column/row/etc (similar to how Control + Up/Down/Right/Left) does.
    There IS a method of disabling this - it involves going into the options menu and disabling the drag-and-drop fill handle:
    Capture.PNG
    However, that's quite a useful function and I'm not massively comfortable disabling it - plus, the settings wouldn't carry over to others using the spreadsheet (I think?)
    Is there a VBA method of doing so - so that I could disable it on the start of the macro and reenable it at the end?
    Thanks,
    Lady Marmalade

    EDIT:
    Guys I'm very sorry for wasting your time. A quick "record actions" on excel figured it out for me. For future reference if anybody comes across a similar issue:

    Please Login or Register  to view this content.
    Last edited by MarmaladeLover; 02-26-2015 at 07:31 AM.

+ 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. Which one is better to Disable Cut & Paste, Drag & Drop
    By RandyD123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2013, 06:37 PM
  2. Replies: 1
    Last Post: 07-06-2010, 06:06 PM
  3. Disable fill handle
    By sverhaeghe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2009, 08:56 AM
  4. [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
  5. Disable drag and drop and cut and paste
    By SteelDetailer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2006, 03: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