Hello, I was wondering, if any of the options below are possible without macros when double-clicking a field that creates a new sheet.
Can the new sheet created, keep the same format (color) as the data source?
Can the new sheet created have a custom name for the tab vs sheet1?
Last edited by AccountingJ; 09-16-2020 at 02:51 PM.
I can't seem to find a macro that does this, anyone have a link that could possible help?
I named the pivot tables in this example, so if possible, I would like the new tabs named after the pivot table.
You'll need to use Before_Double_Click event. And control process via code.
Ex: in Shee2 (Sheet code name Sheet1) module...
See attached.
Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Brother if I could add to your reputation more than once, I would.
Thank you so much
You are welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks