View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vergel Adriano Vergel Adriano is offline
external usenet poster
 
Posts: 857
Default 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