LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to open a workbook with a specific worksheet displayed by defa ThaiNB New Users to Excel 2 January 21st 05 06:11 AM
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 02:47 PM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 10:52 PM
Drag control onto worksheet does not work TRT Excel Discussion (Misc queries) 1 January 6th 05 02:26 AM
Error message opening Excel97 workbook cobbler Excel Discussion (Misc queries) 2 December 11th 04 05:31 PM


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"