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 -

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

You can access data without selecting the sheet, such as
Sheets("Sheet2").Range("B3").Copy

Jerry

"pywhacket" wrote:

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 -

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

I am very much a novice when it comes to VBA, Ia m trying to learn. I
substituted what is below and I get runtime error 9 Subscript out of range -
what am I doing wrong


Application.ScreenUpdating = False
Sheets("Sheet10").Select
Range("A1").Selec

"pywhacket" wrote:

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 -

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

Macro recording produces very fat code

Sheets("Sheet10").Select
Range("A1").Select

can be collapsed into

Sheets("Sheet10").Range("A1").Select

which would still error. You did not include the action to be performed on
A1, but that too can probably be combined together into a single statment
that does not involve Select (see my previous poste for an example).

Jerry

"pywhacket" wrote:

I am very much a novice when it comes to VBA, Ia m trying to learn. I
substituted what is below and I get runtime error 9 Subscript out of range -
what am I doing wrong


Application.ScreenUpdating = False
Sheets("Sheet10").Select
Range("A1").Selec

"pywhacket" wrote:

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 -

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

Thank you!

"Jerry W. Lewis" wrote:

Macro recording produces very fat code

Sheets("Sheet10").Select
Range("A1").Select

can be collapsed into

Sheets("Sheet10").Range("A1").Select

which would still error. You did not include the action to be performed on
A1, but that too can probably be combined together into a single statment
that does not involve Select (see my previous poste for an example).

Jerry

"pywhacket" wrote:

I am very much a novice when it comes to VBA, Ia m trying to learn. I
substituted what is below and I get runtime error 9 Subscript out of range -
what am I doing wrong


Application.ScreenUpdating = False
Sheets("Sheet10").Select
Range("A1").Selec

"pywhacket" wrote:

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 -

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

"pywhacket" wrote:

Thank you!

You're welcome. Glad it helped.

Jerry