Re: How to control worksheet initialization upon opening a workbook

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Nick (nico_zin_at_yahoo.com)
Date: 10/31/04 

Date: 31 Oct 2004 04:55:37 -0800

No offence, but what exactly are you talking about?
I'm looking for suggestions not opinions.

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message news:<OfziSitvEHA.1296@TK2MSFTNGP10.phx.gbl>...
> 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" <nico_zin@yahoo.com> wrote in message
> news:1ff3001a.0410301352.35799e4c@posting.google.com...
> > 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.

Relevant Pages

  • RE: Variables initiation
    ... Public wHide, wHide2, wHide3 As Worksheet ... initialize my variable to a specific value my macros might fail depending on ... initilize my variable before any macro is excecuted so regardless or the ... Private Sub UserForm_Initialize ...
    (microsoft.public.excel.programming)
  • Qn: Worksheet Open???
    ... Is there a way initialize a worksheet when it is opened. ... with a workbook when it is opened, but I wanted to put a subroutine that ... would you like to complete your setup now?? ...
    (microsoft.public.excel.programming)
  • RE: VBA VLookup or equivalent
    ... Dim wks As Worksheet ... 'Initialize the destination worksheet ... I have an employee number in column b in a file named test, ...
    (microsoft.public.excel.programming)
  • Re: How to control worksheet initialization upon opening a workbook
    ... What I was talking about was that a generic initialize method would be ... >>> certain buttons on each worksheet. ... >>> Private Sub Workbook_Open ... >>> Am I completely off-base with my approach? ...
    (microsoft.public.excel.worksheet.functions)
  • RE: VBA VLookup or equivalent
    ... I think you should put all the data together in a single worksheet, ... Dim wks As Worksheet ... 'Initialize the destination worksheet ... I have an employee number in column b in a file named test, ...
    (microsoft.public.excel.programming)