F2 moving cells with mouse

[will29]

I'm at a bit of a loss here. On every version of excel I've ever used (currently 2016) when you disable "Allow Editing Directly within Cell" you can then press F2 where the cells used in the formula will be highlighted by various colors and with the left mouse button you could move the highlighted color cell used in the formula. Now when I attempt this I have to press the right mouse button instead which is actually annoying and awkward to drag cells.

Any advice?

 

[bobsan42]

save the filename before saving the file to the new location. After successful ssaving delete old file.
something like this:

dim varFile as string
varFile = thisworkbook.path & "\" & thisworkbook.name

[I].... your code for saving to new location ....[/I]

Dim objFS as object
Set objFS = CreateObject("Scripting.FileSystemObject")
objFS.DeleteFile varFile, True

 

[bobsan42]

Sorry - posted in the wrong place

 

[bobsan42]

AFAIK regardless of the status of Allow editing Directly within Cell option after entering the cell (or the Formula Bar) the ranges (cells) included in the formula are highlighted and you can drag them around with either mouse button.

 

[will29]

AFAIK regardless of the status of Allow editing Directly within Cell option after entering the cell (or the Formula Bar) the ranges (cells) included in the formula are highlighted and you can drag them around with either mouse button.

Unfortunately if I use the left mouse button to drag it will just click into that cell. Only the right key will drag it. When I go to my other computers it works as I historically recalling it working being able to use the left mouse button.

 

[bobsan42]

Have you installed any specific mouse drivers and probably changed some settings?

 

[will29]

Nope, our work computers only allow you to install drivers that work via plug n play. You can't install any specific software. Unless maybe those auto downloaded drivers via plug n play messed with some setting.