Implant macro

Resolved · High Priority · Version 2007

Sat 11 Dec 2010, 07:46 Delegate Tom said...

Tom has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Excel VBA Advanced course
Access Introduction course

Implant macro

I am creating a new wookbook via code. I want to set up a macro plus macro button on the new code-created workbook. How can I 'implant' the macro?

Wed 15 Dec 2010, 12:51 Trainer Anthony said...

RE: implant macro

Hi Tom, thanks for your query. Easiest way to quickly for this is...to record yourself doing precisely that as a macro! Here's the code I got from doing a quick macro of my actions:

ActiveSheet.Buttons.Add(218.25, 81.75, 117.75, 24).Select
Selection.OnAction = "mymacro"

Bit of an anti-climax, isn't it?!

Hope this helps,

Anthony

Fri 17 Dec 2010, 07:56 Delegate Tom said...

RE: implant macro

Thanks, Anthony.

Very helpful; i.e. works.

Anti-climax? Yes and no; it opens many doors.

Regards,

Tom

Fri 17 Dec 2010, 11:47 Trainer Anthony said...

RE: implant macro

No problem Tom. Two lines of code, but a lot of potential. I hope it proves useful.

Anthony

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips