[dba-Tech] Open to a specific worksheet

Susan Harkins ssharkins at gmail.com
Sun Feb 15 19:41:40 CST 2009


Thanks Mike -- yeah, I know about the Open and Load events -- I was looking 
for an actual workbook setting. I don't think there is one!

Susan H.
----- Original Message ----- 
From: "Mike Mattys" <mmattys at rochester.rr.com>
To: "Discussion of Hardware and Software issues" 
<dba-tech at databaseadvisors.com>
Sent: Sunday, February 15, 2009 8:18 PM
Subject: Re: [dba-Tech] Open to a specific worksheet


> Hi Susan,
>
> Hope this isn't too late!
>
> As I'm working at Excel automation dlls right now, I chanced to run into
> this:
>
> http://www.vickywoodard.com/teaching/excel/Julian's%20Macro%20Tips.htm
>
> Auto Run [24/12/2001]
> Making your macros run automatically when opening your workbook. You can
> either use the Auto Open method or the Workbook Open method. These macros
> will display the message "Hello" when you open the workbook.
>
> Sub Auto_Open()
> Msgbox("Hello")
> End Sub
>
> This code would be located in the module. However if you use the second
> method, the code must be in the workbook (double click "This Workbook" in
> the explorer window). Click on the drop down list (that says General) and
> select Workbook. Click on the drop down list (that says declarations) and
> select Open.
>
> Private Sub Workbook_Open()
> Msgbox("Hello")
> End Sub
>
> -
> Michael R Mattys
> MapPoint and Database Dev
> www.mattysconsulting.com
> -
> ----- Original Message ----- 
> From: "Susan Harkins" <ssharkins at gmail.com>
> To: "Discussion of Hardware and Software issues"
> <dba-tech at databaseadvisors.com>
> Sent: Friday, February 13, 2009 2:06 PM
> Subject: Re: [dba-Tech] Open to a specific worksheet
>
>
>>I wanted to write about the macro, but didn't want to sound like an
>>idiot --
>> "Hey... idiot... there's a setting for that..." :)
>>
>> Susan H.
>>
>>
>>> Not as far as I know. Code is the only way to go.
>>>
>>> Bryan
>>>
>>> On Fri, Feb 13, 2009 at 9:14 AM, Susan Harkins <ssharkins at gmail.com>
>>> wrote:
>>>> :)
>>>>
>>>> I know I can write a macro -- I was wondering if there was a setting,
>>>> kind
>>>> of like displaying a specific form in Access.
>>>>
>>>>
>>>>> It is there. You can get there in several ways. Open the workbook and
>>>>> then
>>>>> issue:
>>>>>
>>>>> Sheets(name or number).Select
>>>>>
>>>>> in your VBA code.
>>>>>
>>>>> As I recall, the array is zero-based.
>>>>>
>>>>> Arthur
>>>>>
>>>>> On Thu, Feb 12, 2009 at 3:49 PM, Susan Harkins <ssharkins at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> I'm not seeing a setting that allows me to specify what worksheet is
>>>>>> visible
>>>>>> when I open an Excel workbook. Now, I know I can do this with a quick
>>>>>> macro,
>>>>>> but I'd like to make sure there's no setting for this???? Seems like
>>>>>> there
>>>>>> would be.
>>>>>>
>>>>>> Susan H.
>>>>>>
>>>>>> _______________________________________________
>>>>>> dba-Tech mailing list
>>>>>> dba-Tech at databaseadvisors.com
>>>>>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>>>>>> Website: http://www.databaseadvisors.com
>>>>>>
>>>>> _______________________________________________
>>>>> dba-Tech mailing list
>>>>> dba-Tech at databaseadvisors.com
>>>>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>>>>> Website: http://www.databaseadvisors.com
>>>>
>>>> _______________________________________________
>>>> dba-Tech mailing list
>>>> dba-Tech at databaseadvisors.com
>>>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>>>> Website: http://www.databaseadvisors.com
>>>>
>>>
>>>
>>>
>>> -- 
>>> Bryan Carbonnell - carbonnb at gmail.com
>>> Life's journey is not to arrive at the grave safely in a well
>>> preserved body, but rather to skid in sideways, totally worn out,
>>> shouting "What a great ride!"
>>> _______________________________________________
>>> dba-Tech mailing list
>>> dba-Tech at databaseadvisors.com
>>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>>> Website: http://www.databaseadvisors.com
>>
>> _______________________________________________
>> dba-Tech mailing list
>> dba-Tech at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/dba-tech
>> Website: http://www.databaseadvisors.com
>>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 




More information about the dba-Tech mailing list