Posted to microsoft.public.excel.programming

Russell Lucas Russell Lucas is offline

external usenet poster

Posts: 8

Visible property on Worksheets

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Windows Visible Property - Code Help	Gerry O	Excel Discussion (Misc queries)	2	September 6th 07 02:44 AM
Visible Property	Steve A[_2_]	Excel Programming	1	January 5th 04 12:35 PM
Run-time error '1004' - Unable to set the Visible property of the Worksheet class	Shalin Chopra	Excel Programming	3	November 25th 03 08:38 PM
Loop thru multiple files - Modify worksheet visible property	Mike Taylor	Excel Programming	1	October 24th 03 04:03 AM
.Visible Property	Jollynicechap	Excel Programming	1	July 8th 03 09:06 PM

All times are GMT +1. The time now is 12:40 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us