Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a toolbar with customized buttons
Make a floating toolbar with some colour and pattern buttons, that run only in a specific worksheet. :confused -- jobee ----------------------------------------------------------------------- jobeer's Profile: http://www.excelforum.com/member.php...fo&userid=3244 View this thread: http://www.excelforum.com/showthread.php?threadid=52315 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make a toolbar with customized buttons
See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm You would use the worksheet activate and deactivate events or possibly do it at the workbook level. It would probably be easiest to build your commandbar manually and then attach it to your workbook. The alternative is to build it with code (this obviously is more robust). http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel 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. -- Regards, Tom Ogilvy "jobeer" wrote: Make a floating toolbar with some colour and pattern buttons, that runs only in a specific worksheet. -- jobeer ------------------------------------------------------------------------ jobeer's Profile: http://www.excelforum.com/member.php...o&userid=32447 View this thread: http://www.excelforum.com/showthread...hreadid=523157 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Customized Toolbar Macro Buttons | Setting up and Configuration of Excel | |||
make buttons bigger on quick access toolbar | Excel Discussion (Misc queries) | |||
Make toolbar buttons appear only in specific files? | Excel Programming | |||
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! | Excel Programming | |||
How to make toolbar buttons larger? | Excel Programming |