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. |
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) |