LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Need help with adjusting width of VBA-created toolbars

Thanks Bernie,
After reading your response I tried my macro again and discovered you
were right: The toolbar width was automatically adjusting to the
caption. What had fooled me was the fact that the toolbar was coming
out a little wider than neccessary, causing extra space after the
caption. I fooled around some more and took care of this problem by
removing the following line of code:

.Controls.Add Type:=msoControlButton

Thanks for helping lead me to this fix.

Mark
 
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
Change Cell Width WITHOUT changing Column width dww701 Excel Discussion (Misc queries) 1 January 12th 09 10:52 PM
adjusting column width using keystrokes Lesliec4000 Excel Discussion (Misc queries) 1 May 18th 07 04:07 PM
ASC() does not convert full-width to half-width letters (Exel 2003 DY Excel Worksheet Functions 0 January 27th 07 01:34 PM
Toolbars Created in Excel 2002 not available in 2003 VBA Fun Excel Discussion (Misc queries) 3 August 25th 05 12:47 PM


All times are GMT +1. The time now is 04:53 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"