Command Buttons Outside Spreadsheet
 

I have never used Excel before. I am the director of College Math (Calculus
and Differential Equations) and Football Coach.

The school District is removing Access from almost every computer and also
access to the Internet because too many teachers are goofing off.

I wanted to explain this so that some of my requests do not seem ambiguous.

I need Seven Command Buttons to do different sorts. Is there any way that I
can display the Command Button outside of the data area of the spreadsheet?

Thanks in Advance

Len

Command Buttons Outside Spreadsheet
 

I answer a similar problem earlier this morning. Somebody wanted a floating
button. I suggested adding a button to the toolbar at the top of the
spreadsheet


Rather than add the button to the worksheet add a button to the toolbar in
excel. Go to View Toolbars - Customized.
Select Macro - Custom Button.
Drag button to toolbar.
Double Left Click new button to assign to a macro.

"pswanie" wrote:

i go right click on tools, click on forms and through that add a button to
wich i then assign a macro..

how (if possible) can i have that to "float" when users scroll up/down on a
worksheet?

thanx phillip



"Len" wrote:

I have never used Excel before. I am the director of College Math (Calculus
and Differential Equations) and Football Coach.

The school District is removing Access from almost every computer and also
access to the Internet because too many teachers are goofing off.

I wanted to explain this so that some of my requests do not seem ambiguous.

I need Seven Command Buttons to do different sorts. Is there any way that I
can display the Command Button outside of the data area of the spreadsheet?

Thanks in Advance

Len

Command Buttons Outside Spreadsheet
 

Joel;
Thanks it worked!
Len

"Joel" wrote:

I answer a similar problem earlier this morning. Somebody wanted a floating
button. I suggested adding a button to the toolbar at the top of the
spreadsheet


Rather than add the button to the worksheet add a button to the toolbar in
excel. Go to View Toolbars - Customized.
Select Macro - Custom Button.
Drag button to toolbar.
Double Left Click new button to assign to a macro.

"pswanie" wrote:

i go right click on tools, click on forms and through that add a button to
wich i then assign a macro..

how (if possible) can i have that to "float" when users scroll up/down on a
worksheet?

thanx phillip



"Len" wrote:

I have never used Excel before. I am the director of College Math (Calculus
and Differential Equations) and Football Coach.

The school District is removing Access from almost every computer and also
access to the Internet because too many teachers are goofing off.

I wanted to explain this so that some of my requests do not seem ambiguous.

I need Seven Command Buttons to do different sorts. Is there any way that I
can display the Command Button outside of the data area of the spreadsheet?

Thanks in Advance

Len