how to put in buttons?

[choungeehowe]

My teacher told me it has something to do wif macros but i dont understand her at all. I want buttons so that the spreadsheet looks more presentable. How do i do that? i want a main menu button, calculation button , print button and such. any help?

[y2k]

Click view>toolbars and select "control Toolbox". you can use this to "draw" buttons on your sheet, however, you'll need to assign macro's to them in order for them to do anything. I don't know if this is of any help?

[choungeehowe]

okay ... thats the part i dont know what to do ... the macros ... wat do i type in?? all i want is just to click the button and it will direct me to another sheet. thats all simple as that... i dont know anything about macros so tell me some commands for it?

[Steve Hartman]

So basicly you want someone to do your homework for you?

[choungeehowe]

erm no ... i mean i have already done my spreadsheets and countings and all ... just dat the teacher didnt teach ANYTHING about macros cuz i only jus started using excel like 3 weeks ago. How am i suppose to learn the macros if i dont really know how to utilise excel yet ...

[bobeuk]

You shouldn't need to use macros. You can hyperlink from a button or a text box if you simply want to move between sheets.

John

Setting up a basic Macro is a bit like recording a tape - Excel will convert all of your steps into computer code.

To put in Print Button, follow these steps:

On the menu bar, go to Tools/Macro/Record New Macro/ give it a name "Print Form"

Then a small box will appear on your sheet - ignore this for the moment.

Now go through all the usual steps you would go through to print a sheet e.g. select File/Print etc.

When you have done all of that, go back to the small box on your sheet and click on the square - that will stop the Macro Recording.

You have now recorded a Macro that will Print your sheet. Now you have to connect this Macro to a button.

Go to View/Toolbars and click on "Forms".

Select the icon that reads "Button" when you hover over it. Then move your mouse to the position on the sheet where you want the button to sit. Click&Drag your mouse to the size of button you want.
When you let go of the mouse, a box will appear, with your "Print Form" macro in it. Select the "Print Form" macro and click OK.

Close the Form Toolbar. Right mouse click on the Button and change the text to read "Print Form".

You've now created a Macro and assigned it to a button. If you want to see the program code that has been created when you recorded your macro, go to Tools/Macro/Visual Basic Editor, double click on "Modules", then double click on "Module 1" - this is your VBA code.

Cheers!

[choungeehowe]

alrite thanx everyone