ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VeryHidden (https://www.excelbanter.com/excel-programming/339929-veryhidden.html)

Darin Kramer

VeryHidden
 
Hi...

Whats the VB to select sheet a and sheet b and make them very hidden?

Then the corresponding VB to select sheet a and sheet b and make them
visible?

Thanks a mill....
D

*** Sent via Developersdex http://www.developersdex.com ***

Dr. Stephan Kassanke

VeryHidden
 

"Darin Kramer" schrieb im Newsbeitrag
...
Hi...

Whats the VB to select sheet a and sheet b and make them very hidden?

Then the corresponding VB to select sheet a and sheet b and make them
visible?

Thanks a mill....
D

*** Sent via Developersdex http://www.developersdex.com ***


worksheets("A").visible=xlveryhidden
worksheets("A").visible=true

cheers,
Stephan



Bob Phillips[_6_]

VeryHidden
 

"Darin Kramer" wrote in message
...

Whats the VB to select sheet a and sheet b and make them very hidden?


Worksheets("Sheet1").Visible = xlSheetVeryhidden

Then the corresponding VB to select sheet a and sheet b and make them
visible?


Worksheets("Sheet1").Visible = xlSheetVisible




All times are GMT +1. The time now is 09:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com