Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to control worksheet initialization upon opening a workbook
I have 2 worksheets. Each one contains a few buttons.
When I open my workbook, I would like to initialize some of the behavior on each worksheet. For example, I would like to disable certain buttons on each worksheet. I am quite aware of the workbook_open() routine and also aware that I can iterate through the workbook to retrieve each worksheet. However, I find it hard to believe that I can't initialize behavior for each or certain worksheets upon startup. Ideally, I would like to do this: Private Sub Workbook_Open() For Each ws In Worksheets ws.<initialize <----- this would be nice Next ws End Sub Suggestions? Am I completely off-base with my approach? thanks. |
#2
|
|||
|
|||
Yep you are off base. Your view of initialize would be different than mine,
would be different that ... etc. Together with different data combinations, added controls, and so on, and so on, the combinations are many. -- HTH RP "Nick" wrote in message om... I have 2 worksheets. Each one contains a few buttons. When I open my workbook, I would like to initialize some of the behavior on each worksheet. For example, I would like to disable certain buttons on each worksheet. I am quite aware of the workbook_open() routine and also aware that I can iterate through the workbook to retrieve each worksheet. However, I find it hard to believe that I can't initialize behavior for each or certain worksheets upon startup. Ideally, I would like to do this: Private Sub Workbook_Open() For Each ws In Worksheets ws.<initialize <----- this would be nice Next ws End Sub Suggestions? Am I completely off-base with my approach? thanks. |
#3
|
|||
|
|||
No offence, but what exactly are you talking about?
I'm looking for suggestions not opinions. "Bob Phillips" wrote in message ... Yep you are off base. Your view of initialize would be different than mine, would be different that ... etc. Together with different data combinations, added controls, and so on, and so on, the combinations are many. -- HTH RP "Nick" wrote in message om... I have 2 worksheets. Each one contains a few buttons. When I open my workbook, I would like to initialize some of the behavior on each worksheet. For example, I would like to disable certain buttons on each worksheet. I am quite aware of the workbook_open() routine and also aware that I can iterate through the workbook to retrieve each worksheet. However, I find it hard to believe that I can't initialize behavior for each or certain worksheets upon startup. Ideally, I would like to do this: Private Sub Workbook_Open() For Each ws In Worksheets ws.<initialize <----- this would be nice Next ws End Sub Suggestions? Am I completely off-base with my approach? thanks. |
#4
|
|||
|
|||
Sorry, I thought I answered the question
Am I completely off-base with my approach? What I was talking about was that a generic initialize method would be (almost?) limitless in its combinations, thus it is not surprising it doesn't exist. Any suggestions basically would amount to writing an initialize class or something similar that would handle all of your combinations,. but that would probably take more effort that doing what you are doing. -- HTH RP "Nick" wrote in message om... No offence, but what exactly are you talking about? I'm looking for suggestions not opinions. "Bob Phillips" wrote in message ... Yep you are off base. Your view of initialize would be different than mine, would be different that ... etc. Together with different data combinations, added controls, and so on, and so on, the combinations are many. -- HTH RP "Nick" wrote in message om... I have 2 worksheets. Each one contains a few buttons. When I open my workbook, I would like to initialize some of the behavior on each worksheet. For example, I would like to disable certain buttons on each worksheet. I am quite aware of the workbook_open() routine and also aware that I can iterate through the workbook to retrieve each worksheet. However, I find it hard to believe that I can't initialize behavior for each or certain worksheets upon startup. Ideally, I would like to do this: Private Sub Workbook_Open() For Each ws In Worksheets ws.<initialize <----- this would be nice Next ws End Sub Suggestions? Am I completely off-base with my approach? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to open a workbook with a specific worksheet displayed by defa | New Users to Excel | |||
copy COLUMN from 1 worksheet to another (in a different workbook) | Excel Discussion (Misc queries) | |||
How to print a worksheet but number the pages by workbook | Excel Discussion (Misc queries) | |||
Drag control onto worksheet does not work | Excel Discussion (Misc queries) | |||
Error message opening Excel97 workbook | Excel Discussion (Misc queries) |