I have the following macro in a specific tab. How would I change it, so when the user makes a copy of the same tab in the same file, the macro continues to work.
Please Login or Register to view this content.
I have the following macro in a specific tab. How would I change it, so when the user makes a copy of the same tab in the same file, the macro continues to work.
Please Login or Register to view this content.
This is a Private Sub
So I assume that it is sheet specific and the Toggle Button is an Activex Toggle button.
So if you create a copy of the sheet the toggle button and the macro will also be copied.
So you should not need to do anything.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks