Command Buttons Outside Spreadsheet

[Guest]

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

 

[Guest]

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.

 

[Guest]

Joel;
Thanks it worked!
Len

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.