I have been trying to create some specific features in an existing workbook since last week. Here is an outline of what I need:
Create a new page while maintaining the formatting (so basically copy and Move to end)
Launch a dialogue box to prompt to rename the new sheet
Associate with a button
Now, I can create these features independently but not all together. I can't seem to pinpoint in the VBA how to merge them.
Also, I don't know if this is even possible, but my employer would like the button that does all of the above to appear on the new page that is being created.
Help!
Bookmarks