Hi Russel
try
Worksheets("Sheet1").Visible = xlsheetveryhidden

works for me
Frank



Russell Lucas wrote:
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 = xlveryhidden
end with

I have also tryed several ways of defining the worksheet.

Can anyone help out?

Thanks