CommandButton?

  • Thread starter Thread starter Stu
  • Start date Start date
S

Stu

Hi,
Is it possible to have a command button like float on the top right of my
spreadsheet so as someone scrolls down the sheet the button is still there
in the top right?
Any ideas appreciated.

Thanks
 
Also is it possible to get a command button to not print out when a
spreadsheet is printed?

Thanks
 
And is it possible to have that toolbar sent to difference computers within
the file or would people have to make it too?

--
Stu
Michael Wong said:
Why not just create a floating toolbar?
 
Right click on the menu bar.
Click on Customize...
On Toolbars tab, click on New... to create your toolbar.
After creating your toobar, you can Attach it to your workbook.

Stu said:
Because I don't know how to do that.
 
Dave gave you a good source on attaching toolbars and Michael told you how
to create a custom toolbar.

Here are some articles that help you do something useful with the toolbar:

Here is an article which talks about attaching toolbars:

http://www.microsoft.com/exceldev/articles/toolbatt.htm

Next article specifies xl97, but it is good for excel 97 and later.
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.




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

Here is another article or two you might find useful:
http://msdn.microsoft.com/library/backgrnd/html/msdn_addins97.htm
http://msdn.microsoft.com/library/officedev/odeopg/deovrcreatingexceladdin.h
tm
http://www.microsoft.com/exceldev/tips/addins.htm
These are about distributing applications

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


--
Regards,
Tom Ogilvy


Stu said:
And is it possible to have that toolbar sent to difference computers within
the file or would people have to make it too?
 
Back
Top