Adding lines with automatic macros

**psmportland** · 03-29-2010, 06:16 PM

I am trying to create a form where I want to duplicate a line with a pushbutton at the top of the page. No problem so far...
On the line to be duplicated is a button, attached to a macro which adds spaces beneath the line. When I try to copy and paste it, the macro button either stays attached to its original line, or it copies and pastes as a picture, not a macro button.

Effectively, when I duplicate the line, I am wanting it to duplicate the macro but attach it to the new line as well. Is this possible?

Am I nuts?

**martindwilson** · 03-29-2010, 07:03 PM

no you're not nuts! but an example workbook would help

**psmportland** · 03-30-2010, 11:18 AM

Thank you so much-
Effectively, this sheet is for multiple people in my organization to access. When a customer calls and wants to be added to the bid distribution for a given project, the gals at the front desk will be able to do that here.
They will also be able to see. at a glance what we are bidding.
So the estimating guys will log the new projects, using a new projects line, at the top and the admin folks will add requestors to each line.

if there is a better way to do this, I am all over it.
I only know basic Macros, so dont big league me here!

Thanks.