HI buddies
there is an error in the last sequence of this code (bold), and I can not find the reason why
please help
Please Login or Register to view this content.
HI buddies
there is an error in the last sequence of this code (bold), and I can not find the reason why
please help
Please Login or Register to view this content.
wsCopyFrom and ws are range variables. A string is expected.
Try
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Yes that worked. Thank you very much! Last problem to be solved - how to copy the buttons which are in the original sheet? I tried several ways, but can´t get it done.
These are the forms-buttons. I read it is easier to copy them rather than the ActiveX objects. Is that correct? How can I do that? thank you again!
If you use
it will copy Forms buttons along with the rest of the sheet.Please Login or Register to view this content.
If you immediately clear all the cells of the new (copied) sheet, it will leave only the buttons.
If you copy a sheet from one workbook to a different workbook, the buttons on the new sheet will be assigned to macros residing in the first sheet. If the different workbook is to be a stand-alone workbook, the buttons will all have to be assigned to macros in the new workbook.
I ve tried to it like this, but there s an error, hopefuly you can see it..
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks