Just noticed title is wrong. Meant specific column, not row
I am attempting to have set of floating buttons in my sheet. I have managed to accomplish this with the following code:
With ActiveSheet.Shapes("shape name")
.Top = Target.Offset(1).Top
.Left = Target.Offset(, 1).Left
End With
Which works perfectly, but the issue is that I need most of the sheet to be locked and this throws an error if offset destination is in a locked cell. To "overcome" this I have dedicated a non-important range to the floating buttons and have it unlocked. The silly part now is that if the user does not click in the first column of that range it spits an error as at least one of the buttons moving will now be in the locked range.
My question, is there something I can use for the .Left part instead of offset that will always target say column N?
Thanks!
I am attempting to have set of floating buttons in my sheet. I have managed to accomplish this with the following code:
With ActiveSheet.Shapes("shape name")
.Top = Target.Offset(1).Top
.Left = Target.Offset(, 1).Left
End With
Which works perfectly, but the issue is that I need most of the sheet to be locked and this throws an error if offset destination is in a locked cell. To "overcome" this I have dedicated a non-important range to the floating buttons and have it unlocked. The silly part now is that if the user does not click in the first column of that range it spits an error as at least one of the buttons moving will now be in the locked range.
My question, is there something I can use for the .Left part instead of offset that will always target say column N?
Thanks!