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