Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Disable/Enable Fill (2003/SP3)

    Is there any method using VBA, to toggle the Fill Down and Fill Right capability afforded by the lower right corner button of the active cell?

    T.I.A.
    Attached Images Attached Images
    Regards
    Don

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Disable/Enable Fill (2003/SP3)

    It is linked to the ability to drag and drop cells - if you toggle that, you also toggle the fill handle. I'm not aware of a way to turn one on/off without the other. The VBA instruction is

    Application.CellDragAndDrop = Not Application.CellDragAndDrop

  3. #3
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Disable/Enable Fill (2003/SP3)

    Thank you Hans. Exactly what I needed. <img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15> <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15>
    Regards
    Don

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •