[dba-Tech] Open to a specific worksheet

Susan Harkins ssharkins at gmail.com
Fri Feb 13 13:06:42 CST 2009


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 




More information about the dba-Tech mailing list