Unhide version

[graiggoriz]

Hello,

I have various worksheet such as:

Version1, version2, version3, version4, version5 and version6

I have hidden version2, version3, version4, version5 and version6

From version1 worksheet, I would like to create a macro button to allow me to unhide version2 without copying the macro button on the version2 worksheet and staying on the version1 worksheet.

Then the logic would be that if I need another version I would push agin the macro button to.... unhide version3 without copying the macro button on the version3 worksheet and staying on the version1 worksheet.

Many thanks,
Graig

[HaHoBe]

Hi, Graig,

about how many sheets are we talking?

Code goes into ThisWorkbook:

Please Login or Register  to view this content.

Code for the button:

Please Login or Register  to view this content.

Ciao,
Holger

[xladept]

Hi Graig,

Maybe:

Please Login or Register  to view this content.

[graiggoriz]

Hi Holger,

It does exactly what I was expected. The only thing is that I needed to stay on the worksheet "VERSION1" so I added a simple line and it works exactly the way I wanted :D

Many thanks,
Graig

[HaHoBe]

Hi, Graig,

the code from xladept will work as well. If your problem has been solved please mark the thread as Solved via Thread Tools above the first post.

Ciao,
Holger