Posted to microsoft.public.excel.programming

pywhacket

external usenet poster

Posts: 16

macros won't work when tabs with data used are hidden

Hi! I have macros that on a worksheet that run off data on worksheets, in the
same workbook, that need to be hidden when the workbook is distributed.
Whenever I hide them my macros Iget runtime error '1004' Select method of
worksheet class failed.

Is there a way around this?
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
my worksheet tabs are hidden	David	Excel Discussion (Misc queries)	2	July 14th 08 01:58 AM
Tabs hidden	[email protected]	Excel Discussion (Misc queries)	1	January 26th 06 03:20 PM
Hidden tabs	CWH	Excel Discussion (Misc queries)	3	July 29th 05 01:59 PM
excel macros truncating tabs for hidden columns.	SharanS	Excel Discussion (Misc queries)	0	February 17th 05 05:05 AM
Hidden tabs	[email protected]	Excel Discussion (Misc queries)	3	January 19th 05 07:11 PM

All times are GMT +1. The time now is 04:50 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us