macros!!??

[k_eaton]

Help im tryin to finish off an assignment but cant get my head round it!
how do i
1. 'create a macro to automatically copy the template for each product in my spreadsheet???
2. 'create buttons on a template allowing the user to create a graph and post the results within the spreadsheet??
confused!?

[ This Message was edited by: k_eaton on 2002-04-10 08:40 ]

[AJ]

There's quite a bit still to go on your assignment I think! Basically there's no quick answer to your question as it's pretty vague.

To answer the first bit, if you haven't done any VBA before, the simplest thing would be to go to Tools>Macros>Record New Macro.
Then do whatever it is you want to do. Go into the Visual Basic Editor when you've stopped recording and you'll see the code for copying, pasting, switching workbooks, opening workbooks etc.
The board could then help you if you run into trouble etc. if you posted some code or had a more specific query.

Similarly to add buttons to a sheet, a two second guide would run something like...

From the VisualBasic toolbar, click the Control Toolbox.
From there click command button.
Draw the thing on.
Double click it to add code.

Hope this gets you started.
Rgds
AJ

[k_eaton]

hey aj,
thanks for the help. i do know how to create macros im just unsure of how to create a template. its difficult to explain so ill wait and ask my teacher.
another Q.......
'how do i create a small menu on the main menu bar that appears automatically when the spreadsheet is opened?????

[AJ]

Hi,

Adding menus/buttons is not exactly one of my strong points but if you have a look at the post below this works fine to add and remove a button. Perhaps you can adapt it to get a full blown menu??

http://www.mrexcel.com/board/viewtop...c=3823&forum=2

Rgds
AJ