Solved

Deleting Rows/Command Buttons

Posted on 2012-04-12
2
204 Views
Last Modified: 2012-06-27
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
Comment
Question by:Seamus2626
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 37837047
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
 

Author Closing Comment

by:Seamus2626
ID: 37837073
Perfect, thanks ssaqibh

Seamus
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now