Hy all,
I made a script that copy's a sheet, strip is down to value's only and save it. But because of een script running from this sheet whit a userform.show i run in a error.
Is there a better way to copy a sheet values only to a new workbook?
Please Login or Register to view this content.
The code looks OK to me. I don't understand what problem you are trying to solve.
No idea what this means. Looks like you wrote this on a phone. Maybe try again with a little more information.But because of een script running from this sheet whit a userform.show i run in a error.
This is the scribt what triggers an error.
The new file hase a problem with thePlease Login or Register to view this content.because the new sheet does not have this userform.Please Login or Register to view this content.
It looks like you are creating a new file to add the sheet copy. I assume that you do not want any macros in the new file. It also looks like you are ignoring the original Sheet1 in the new file. I am going to use that as the target for your copy:
This will copy the values to the first sheet without copying the VBA code for that sheet.Please Login or Register to view this content.
I run it step by step.
I goes wrong when.Please Login or Register to view this content.
Than there is a
error.Please Login or Register to view this content.
Is it possible to open a new sheet without macro's. .xlsx?
Should that be?
Please Login or Register to view this content.
Let's go back to your original code.
I didn't notice that you were saving as a .xlsx file. That should not have any macros in it. When you re-open it, the error you are describing should not be possible.
What is the same of the workbook containing the macro you are running, with sheet Invulblad?
This code works like a charm on its own.
But when i put this code in "sheet1(invulblad)" there is an error at: "Wachtwoord.Show"Please Login or Register to view this content.
The problem i think is that the new file has the code but not the userform.Please Login or Register to view this content.
So or i make a new .xlsx file instead of a .xslm. Or i delete the code in the sheet after i copy it.
Yes, you should save as a .xlsx file, but it looks like you are saving it as an .xlsx file.
You may need to do this to force the file type:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks