macros!!??

k_eaton

New Member
Joined
Apr 9, 2002
Messages
2
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
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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
 
Upvote 0
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?????
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,072
Members
448,546
Latest member
KH Consulting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top