witzph1
asked on
How to duplicate worksheet with macros and have macros work in new sheet
I have an Excel workbook with a worksheet that has 3 macro buttons on it, each which sorts and filters a table on the worksheet in a different way.
I would like to copy the worksheet with macro buttons to a new worksheet and have the buttons work on the new one. When I copy the worksheet now, the macro buttons on the new worksheet bomb out. I believe because the macro buttons are trying to operate a macro hard coded for another worksheet.
Is there a way to change the macros of the copied sheet easily so they work correctly? Or should I have created the macros differently so they aren't looking for a specific worksheet?
I would like to copy the worksheet with macro buttons to a new worksheet and have the buttons work on the new one. When I copy the worksheet now, the macro buttons on the new worksheet bomb out. I believe because the macro buttons are trying to operate a macro hard coded for another worksheet.
Is there a way to change the macros of the copied sheet easily so they work correctly? Or should I have created the macros differently so they aren't looking for a specific worksheet?
ASKER
Here it is.
Template.xlsm
Template.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is really great! Thank you so much!
You are welcome..Always happy to help.. :-)
Saurabh...
Saurabh...
Either please provide the code or the workbook where you face this problem as it will become faster to help you accordingly..
Saurabh...