[dba-Tech] Open to a specific worksheet

Arthur Fuller fuller.artful at gmail.com
Fri Feb 13 06:44:14 CST 2009


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
>



More information about the dba-Tech mailing list