Stop Macro button moving with cells

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Stop Macro button moving with cells

FAQ

Thread Tools

Display Modes

09-19-2018, 03:46 PM

trevorc

Windows 7 32bit Stop Macro button moving with cells

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

I just found this snippet, I'll play around with this for a while, the button moves with respect to the current cursor position, I may be able to improve on this later.

Code:

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
With ActiveSheet.Shapes("sortAZ")
    .Top = Target.Offset(1).Top
    .Left = Target.Offset(, 1).Left
End With
...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I stop check boxes moving rows when text wraps in an adjacent cell?	PatrickYork	Excel	2	04-04-2018 11:23 AM
Cannot get macro button to sort with merged cells on sheet	lonniepoet	Excel Programming	3	02-04-2016 04:33 PM
data in some cells moving	Sherriann	Excel	1	08-07-2013 06:52 AM
How to stop letter body moving up and down	alankempster	Mail Merge	2	09-13-2012 08:09 AM
Moving formula range multiple cells when moving sum over one cell	FraserKitchell	Excel	4	02-26-2010 10:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 AM.