Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button
Thanks Tom:
I seen that as an alternative in another post but wasnt 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. Im 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
command button
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
command button add another command | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
command button | Excel Discussion (Misc queries) | |||
Command Button vs Control Button | Excel Programming | |||
Command Button vs Form Button | Excel Programming |