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: 111
Default VB's Command Button vs Form's Command Button

Excel 2002, SP3

Here's an issue that I have noticed. When I use VB's Command Button (Visual
Basic Toolbar button, click on Control Toolbox, then click on the command
button within that control bar), each time I go into Print Preview, then
back out, it moves the command button to the left side of the worksheet. To
rectify this issue, I have had to use the Form's (Forms Commandbar) command
button in it's place, which then means that the macro has had to become
public. I have tried various settings, none of which worked for the VB's
command button.

This issue reminds me of the issue that I had in Excel 97 dealing with the
Legend within charts moving on me, which I hated working in Excel 97 due to
it's unstableness in so many different places, even with SR-2 on it. I
would rather work with Lotus 1-2-3, vs 2.3 (Yep, that's the DOS version)
than to work with Excel 97. Excel 2000 was given to me free of charge as a
fix to the legend issue since that wasn't going to be fixed in Excel 97, and
that version of Excel proved to be so much more stable and finally,
something that I would consider as better than Lotus 1-2-3, vs 2.3.

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000


 
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 add another command Wanna Learn Excel Discussion (Misc queries) 5 December 7th 08 11:42 PM
Command Button vs Form Button Bri[_3_] Excel Programming 2 February 3rd 06 08:18 AM
command button abfabrob Excel Discussion (Misc queries) 5 October 7th 05 12:54 AM
Command Button vs Control Button RGibson Excel Programming 1 October 14th 03 02:24 AM
Command Button vs Form Button T K Excel Programming 4 August 26th 03 07:26 PM


All times are GMT +1. The time now is 03:25 AM.

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"