Hello Experts
I know this is simple but not getting a clue on how to do it.
I have a worksheet "Format" where a template is saved. I have used active x controls in this sheet (Submit, Resubmit, Update) and these buttons has got a code also.
When i try copy pasting all these info in to another sheet, only the cells and the form controls getting copied not the activex controls)
how can i go about with this?
Thank u
Is the code behind the worksheet or in a module?
One test is worth a thousand opinions.
Hi Marvin
yes, it is in the module. It is not visible in the macro list.
So you copy a worksheet, how exactly do you copy it?
Can you supply a short example? Do you have acitve x controls on the sheet itself or only on Userforms that come up?
I need more info and to try this to discover what it should do and what you think it should do.
Also what version of XL are you using? Please edit your profile to display this.
I've put an active x command button on sheet 1 and code behind the button.
I then copy the entire sheet and pasted it to another sheet. The control shape is copied to the new sheet but not the code.
My guess is this is the way it works.
ok. I am using Excel 2007
here is the atatchement. When i copy paste the info to sheet 2 only cells are getting pasted not the activex button.
u used activex or form controls?
if i use form controls it is getting copy pasted, but not the active x .. also i dont need the entire sheet to be pasted just few rows along with the button.
any update on this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks