[dba-Tech] Open to a specific worksheet

Susan Harkins ssharkins at gmail.com
Fri Feb 13 08:14:32 CST 2009


:)

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 




More information about the dba-Tech mailing list