[dba-Tech] Open to a specific worksheet

What about a command line argument from a shortcut? I can't find them in
Help but that doesn't mean there isn't one. Anyone know?

Andy Lacey

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: 13 February 2009 19:07
To: Discussion of Hardware and Software issues
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