[dba-Tech] Open to a specific worksheet

Bryan Carbonnell carbonnb at gmail.com
Fri Feb 13 10:54:35 CST 2009


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!"



More information about the dba-Tech mailing list