View Single Post
  #1   Report Post  
Nick
 
Posts: n/a
Default 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.