does the workbook only have one worksheet? at least one worksheet must
remain visible.

What is the error message you get?

--
Regards,
Tom Ogilvy

"Russell Lucas" wrote in message
...
Bob,

Thanks for your reply. The example I gave was taken from a book where I am
using constance rather thana string.

The arguments are correct, but there is application or object error not
allow it. What I'm looking for is a work around to stop, what appears to be
some form of built in protection.

Thanks

----- Bob Phillips wrote: -----

Russell,

If you want to use text strings, you need to enclose in quotes, such
as

Application.Workbooks("BOOK1").Worksheets("Sheet1" ).Visible =
xlsheetveryhidden


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Russell Lucas" wrote in
message
...
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