Open Tab Using Inserted Buttons

[trainer75]

Hi,

Wonder if someone can assist, a colleague of mine created a reporting suite where on a main tab we press a button to open a hidden tab and then when we click off it, it automatically closes it, its a great tool, but I need to add a new tab and a new button to open this.
Unfortunately my colleague has left the business now and isn't contactable.
I have tried looking for some macro or vba that would link to the other tabs but I cannot find anything.
In my mind I would expect to see some code that I can copy and change the tab name to the new tab I want to open and assign it to the button ive created.
is there a way of finding if there is some hidden code?

Hope this makes sense and someone will be able to assist me.

Thank you in advance

 

[mumps]

I think that it would be easier to help and test possible solutions if I could work with your actual file which includes any macros you are currently using. Perhaps you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do using a few examples from your data and referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.