Excel - keep a command button from moving after code runs?

G

Guest

Hi! I've added several command buttons to an excel spreadsheet with some VB
code behind them to set print ranges, sort, etc. The last step of the macro
is to make the active cell A3. When this happens, all the command buttons
I've added move from the far right side of the worksheet to the middle of the
worksheet. Can I "lock" their location to be in a specific cell rather than
floating in relationship to the view of the spreadsheet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I move an ActiveX control (command button) in a worksheet? 1
Hide a command button 9
Command button on worksheet 4
Command button naming issue 1
paste value column based on first cell command button 1
locking and unlocking a textbox using command buttons 1
Referencing command button on worksheet from VBA 3
Adding a Custom Command Button to the Excel 2007 Ribbon 1

Top