Copying buttons & Excel

[RicksAtWork]

I am dynamically worksheets i.e. the worksheet is created and data is copied to it.

However I now want to add a button onto the sheet which will call a specific macro.

Is this posible via VBA?

 

[SkipVought]

Hi,

Why not have a sheet "template" that already has the macro-assigned button on it?


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[RicksAtWork]

This was my oridinal plan however I couldn't work out how to duplicate a worksheet without copying the cells.

How do you do the duplication?

 

[PHV]

Have a look at the Workbooks.Add(Template) method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RicksAtWork]

Actually I've sorted this - however

I have a button that calls a macro.

Is it possible within the macro to determine which worksheet the button was on?

 

[SkipVought]

Yes,

The Parent property of the Shape is the Sheet.


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[PHV]

You may also have a look at the Application.Caller method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886