[dba-Tech] Open to a specific worksheet

That would be cool I guess -- different users might wnat to open to a 
different worksheet. I'll look into that.

Susan H.

> 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
>
>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com