command button

[Guest]

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

 

[Tom Ogilvy]

Commandbars/toolbars have buttons and float. Why not use one of those?

 

[Guest]

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]

Here is an article about creating commandbars with code:
http://msdn.microsoft.com/library/techart/ofcmdbar.htm


http://msdn.microsoft.com/library/officedev/office97/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.aspx?scid=kb;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/techart/msdn_replace.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrworkingwithcommandbarcontrols.htm
http://msdn.microsoft.com/library/officedev/office97/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