Posted to microsoft.public.excel.programming

Edy[_2_]

external usenet poster

Posts: 3

Help on Visible Property

I would like to ask help from anyone in the group regarding the this
error everytime I run my macro. It used to run before but all of a
sudden, i don't know what went wrong, but it won't.

Macro code:
Worksheets("Tables").Visible=xlSheetVeryHidden

This is the error:
Run-time error '1004':
Unable to set the Visible property of the worksheet class.

Thanks for the help.

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
how to set pivotitem.visible property to true	Amedee Van Gasse	Excel Programming	4	January 10th 08 03:32 PM
VBA visible property	miek	Excel Programming	1	November 24th 05 04:47 AM
Visible property on Worksheets	Russell Lucas	Excel Programming	5	February 5th 04 03:26 PM
Visible Property	Steve A[_2_]	Excel Programming	1	January 5th 04 12:35 PM
.Visible Property	Jollynicechap	Excel Programming	1	July 8th 03 09:06 PM

All times are GMT +1. The time now is 05:34 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us