Thread
:
Excel - keep a command button from moving after code runs?
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Jones
external usenet poster
Posts: 5,302
Excel - keep a command button from moving after code runs?
Hi Dave,
See: MSKB Article # 838910:
(Controls move to the left of the worksheet in Microsoft Excel 2002)'
http://tinyurl.com/6cp72
See also the final contribution (from Bob Phillips) in the following thread:
http://tinyurl.com/co6ae
---
Regards,
Norman
"Dave Little" <Dave
wrote in message
...
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?
Reply With Quote
Norman Jones
View Public Profile
Find all posts by Norman Jones