Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm
http://msdn.microsoft.com/library/of...97/web/008.htm
MS Officer 97 Programmer's Guide
Chapter 8: Menus and Toolbars
http://support.microsoft.com/?id=159619
XL97: Sample Macros for Customizing Menus and Submenus
http://support.microsoft.com/?id=213550
XL2000: Sample Macros for Customizing Menus and Submenus
http://support.microsoft.com/default...b;en-us;166755
File Title: Customizing Menu Bars, Menus, and Menu Items in Microsoft(R)
Excel 97
File Name: WE1183.EXE
File Size: 58041 bytes
File Date: 06/20/97
Keywords: kbfile kbappnote
Description: This Application Note can help you learn techniques for writing
Visual Basic(R) for Applications code to customize menus in Microsoft Excel
97. This Application Note contains code examples that you can use with the
following elements: menu bars, menus, menu items, submenus, and shortcut
menus.
http://support.microsoft.com/?id=288771
HOWTO: Create a Transparent Picture For Office CommandBar Buttons
http://support.microsoft.com/?id=160293
ACC97: How to Dim Menu Items or Disable Toolbar Buttons in Visual Basic for
Applications
http://support.microsoft.com/?id=198464
ACC2000: How to Dim Menu Items or Disable Toolbar Buttons in VBA
http://support.microsoft.com/?id=158550
XL97: Problems Disabling and Enabling Shortcut Menus
http://support.microsoft.com/?id=213561
XL2000: Problems Disabling and Enabling Shortcut Menus
http://support.microsoft.com/?id=213563
XL2000: Cannot Make Changes to Some Shortcut Menus
http://support.microsoft.com/?id=158434
XL97: Cannot Make Changes to Some Shortcut Menus
http://support.microsoft.com/?id=213209
XL2000: Sample Macros that Customize and Control Shortcut Menus
http://support.microsoft.com/?id=162878
XL97: Sample Macros That Customize and Control Shortcut Menus
http://support.microsoft.com/?id=213757
XL2000: How to Turn off Shortcut Menus
http://support.microsoft.com/?id=161440
XL97: How to Disable Shortcut Menus
http://support.microsoft.com/?id=170563
OFF97: How to Prevent Customization of Menus and Toolbars
Sub DisableToolbarMenu()
CommandBars("Toolbar List").Enabled = False
End Sub
http://support.microsoft.com/?id=161926
XL97: How to Place a Checkmark Next to a Menu Item
http://support.microsoft.com/?id=213735
XL2000: How to Place a Check Mark Next to a Custom Menu Item
http://support.microsoft.com/?id=211543
XL2000: Cannot Modify or Delete Custom Menus
http://support.microsoft.com/?id=213563
XL2000: Cannot Make Changes to Some Shortcut Menus
http://support.microsoft.com/?id=213700
XL2000: Custom Toolbar Is Added Above Existing Toolbars
http://support.microsoft.com/?id=167382
XL97: How to Restore a Built-In Menu
http://support.microsoft.com/?id=213708
XL2000: How to Hide and Restore a Built-In Menu
=====================
http://support.microsoft.com/?id=241652
BUG: Changes Made to Excel CommandBars Through Automation Are Not Saved
This says it is fixed in SR1:
http://support.microsoft.com/?id=249066
XL2000: Changes Aren't Saved When Altering or Resetting Toolbars Using
Automation
=====================
from Stratos:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm
http://msdn.microsoft.com/library/te...dn_replace.htm
http://msdn.microsoft.com/library/of...arcontrols.htm
http://msdn.microsoft.com/library/of...97/web/008.htm
http://support.microsoft.com/?id=159466
Q159466 - XL97: List of ID Numbers for Built-In Command Bar Controls
http://support.microsoft.com/?id=213552
Q213552 - XL2000: List of ID Numbers for Built-In CommandBar Controls
http://support.microsoft.com/?id=162814
Q162814 - XL97: Sample Macros to Return ID for a CommandBar Control
http://support.microsoft.com/?id=213211
Q213211 - XL2000: Sample Macros to Return ID for a CommandBar Control
--
Regards,
Tom Ogilvy
"TK" wrote in message
...
Thanks Tom:
I seen that as an alternative in another post but wasn't able to
find any documentation as to how to implement it could you
be a little more specific.
Are you referring to adding a button to the excel toolbar or adding
a toolbar. I'm familiar with building button bars est. in VB I just need a
little nudge in the right direction for Excel.
Thanks
TK
"Tom Ogilvy" wrote:
Commandbars/toolbars have buttons and float. Why not use one of those?
--
Regards,
Tom Ogilvy
"TK" wrote in message
...
Hi:
Is there a setting or a way or a command button that
will float above the screen other than using a form?
Thanks
TK