[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Deleting Rows/Command Buttons

Hi,

I have some code that moves a few things around, does some stuff and deletes some rows

I have two comman buttons on the sheet, when it deletes rows it moves these buttons around.

Is there anyway i can lock these buttons from moving?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Saqib Husain, SyedEngineerCommented:
You can use these statements to get the values

debug.print Commandbutton1.Top
debug.print Commandbutton1.height

and you can assign these values in a worksheet_change event like this

Commandbutton1.Top = 100
Commandbutton1.height = 10

***edited***
0
 
Seamus2626Author Commented:
Perfect, thanks ssaqibh

Seamus
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now