ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hiding a Worksheet (https://www.excelbanter.com/excel-programming/386141-re-hiding-worksheet.html)

Vergel Adriano

Hiding a Worksheet
 
Try it this way:

worksheets(1).visible = xlSheetVeryHidden


--
Hope that helps.

Vergel Adriano


"Marek" wrote:

Hi,

Am trying to hide a worksheet through VBA code. The line of code below
ought to do that:

worksheets(1).visible = xlveryhidden

But it doesn't work!!

Anyone with ideas??

--
Many thanks in advance for any assistance
Marek



All times are GMT +1. The time now is 02:39 AM.

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