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
--
Stu

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

Thanks
--
Stu

Why not just create a floating toolbar?

"Stu" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> 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
> --
> Stu
>
>

Because I don't know how to do that.

--
Stu



"Michael Wong" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Why not just create a floating toolbar?
>
> "Stu" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> > 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
> > --
> > Stu
> >
> >
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Why not just create a floating toolbar?
>
> "Stu" <(E-Mail Removed)> wrote in message
> news:#(E-Mail Removed)...
> > 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
> > --
> > Stu
> >
> >
>
>

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" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> Because I don't know how to do that.
>
> --
> Stu
>
>
>
> "Michael Wong" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Why not just create a floating toolbar?
> >
> > "Stu" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> > > 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
> > > --
> > > Stu
> > >
> > >
> >
> >
>
>

You can attach a toolbar to an excel workbook.

Tools|customize|Toolbars Tab|Attach button.

Jan Karel Pieterse has posted some nice instructions for attached toolbars:
http://google.com/groups?threadm=083...280a%40phx.gbl

Stu wrote:
>
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Why not just create a floating toolbar?
> >
> > "Stu" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> > > 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
> > > --
> > > Stu
> > >
> > >
> >
> >

--

Dave Peterson
(E-Mail Removed)

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...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.




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/ba...n_addins97.htm
http://msdn.microsoft.com/library/of...ngexceladdin.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 <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Why not just create a floating toolbar?
> >
> > "Stu" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> > > 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
> > > --
> > > Stu
> > >
> > >
> >
> >
>
>