Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros won't work when tabs with data used are hidden
"pywhacket" wrote:
Thank you! You're welcome. Glad it helped. Jerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my worksheet tabs are hidden | Excel Discussion (Misc queries) | |||
Tabs hidden | Excel Discussion (Misc queries) | |||
Hidden tabs | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
Hidden tabs | Excel Discussion (Misc queries) |