Hide and Show worksheets

[Gregm66]

Hi everyone

I have a question in regards to hiding worksheets.. i do know how to do this in the usual manner.

although i was wondering is there a way using vba to hide a worksheet, and then show the worksheet if a user clicks on a button, then once the user goes back to the main dashboard the sheet tab is no longer visible?

Thanks in advance

 

[Michael M]

Greg
Have at a look at this thread.
If you need further help, post back

https://www.mrexcel.com/forum/excel-questions/973802-vba-unhide-sheet-then-re-hide.html

 

[Gregm66]

Thanks for your reply Michael M,

I will look at those vba codes and addapt for my use

Thankyou very much for your help