Hello everyone

Does anyone know how you can change the default "xlsheetvisible" setting for Worksheet.visible through VBA, bearing in mind that I have tryed all of the bellow conitations of code:

Application.Workbooks(BOOK1).Worksheets(Sheet1).Vi sible = xlsheetveryhidden

With Workbooks(BOOK1).Worksheets(Sheet1
.visible = xlveryhidde
end wit

I have also tryed several ways of defining the worksheet

Can anyone help out

Thanks