How to copy/paste 2 buttons in exact same place on every worksheet

**EK1** · 03-01-2010, 12:59 PM

As the title says...I have two buttons on the main page and I want to copy that onto every worksheet in the same location. When I try copy and paste, it pastes in a random place and I have to move it to an approximate place....I'm basically looking for something like "copy with base point" as one can find in Autocad.

**EK1** · 03-01-2010, 03:21 PM

bump...anyone?

**ravishankar** · 03-02-2010, 12:13 PM

Hi
This macro adds command button to all sheets at the preset place. Change the co-ordinates (Left, top, width and height) to suit your case

Please Login or Register  to view this content.

Ravi

**EK1** · 03-02-2010, 12:17 PM

Works great. Thanks.

That's one problem solved. Could you chime in on my other thread as well (regarding userforms and my pathetic struggles to get it working)