ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hide worksheet (https://www.excelbanter.com/excel-programming/282942-hide-worksheet.html)

Lawlera

Hide worksheet
 
Is it possible to 'hide' a single worksheet within an Excel XP workbook?

Jan Karel Pieterse

Hide worksheet
 
Hi Lawlera,

Is it possible to 'hide' a single worksheet within an Excel XP workbook?


Worksheets("Yoursheet").Visible=False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com


Lawlera

Hide worksheet
 
Thanks a million!


All times are GMT +1. The time now is 01:26 PM.

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