Disable CellDragAndDrop for FillRight AND FillLeft

[Emily]

Is there any method to disable CellDragAndDrop during FillLeft and FillRight, i.e only allow FillDown?

Thanks
Emily

 

[BrianB]

No. It is "all or nothing" via Tools/options/Edit

You could, however, write a macro to do the FillDown. Record a macro (without using Filldown) and come back with any problems. We need details of how you want to use it.