Hello,
I have a workbook with multiple tabs and what I'd like to do is create an ActiveX button (or any button) that when clicked copies the worksheet and opens it into another workbook with just that tab. Is this doable? Just a note, I'm a beginner to excel coding so need a lot of direction.
Thanks,
Laura
Hi Laura,
The code that you need is:
Copy that into a new module into VBA and when you run it, it will copy the sheet that is currently active to a new workbook.
Please Login or Register to view this content.
To assign it to a "button" you can either use a Form Control button or even just a shape and then just right click on the shape and select "Assign Macro" and then select the code "CopySheet".
Hope this helps
Regards,
Stephen
If you feel someone has helped you please thank them and click on the star on their post to add reputation.
Please ensure that you use code tags where relevant, and mark solved threads as solved.
Most of all please be respectful and understanding of others.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks