Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 30th 04, 10:52 PM
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.

  #2   Report Post  
Old October 31st 04, 12:31 AM
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Old October 31st 04, 01:55 PM
Nick
 
Posts: n/a
Default

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   Report Post  
Old October 31st 04, 05:36 PM
Bob Phillips
 
Posts: n/a
Default

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
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 07:11 AM
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 03:47 PM
How to print a worksheet but number the pages by workbook Frank Clayton Excel Discussion (Misc queries) 2 January 10th 05 11:52 PM
Drag control onto worksheet does not work TRT Excel Discussion (Misc queries) 1 January 6th 05 03:26 AM
Error message opening Excel97 workbook cobbler Excel Discussion (Misc queries) 2 December 11th 04 06:31 PM


All times are GMT +1. The time now is 07:11 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017