LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel - keep a command button from moving after code runs?

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
command button code dummy Excel Discussion (Misc queries) 2 December 1st 09 02:57 PM
VBA code behind command button [email protected] Excel Worksheet Functions 1 March 22nd 06 08:13 PM
Command Button VBA code Dave Peterson Excel Discussion (Misc queries) 2 January 25th 05 11:28 PM
Command Button keeps moving! ForSale[_31_] Excel Programming 3 August 12th 04 03:53 AM
Moving the Command Button alexm999[_18_] Excel Programming 3 January 31st 04 10:48 PM


All times are GMT +1. The time now is 11:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"