On opening a spreadsheet.

On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook, not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.

Thanks for that, do u think u could shed some light on my
other post, Macros - Filters. That would great.

Cheers
-----Original Message-----
Private Sub Workbook_Open()
Worksheets("Sheet name").Select
End Sub



"Pinda" wrote in message
...
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook,
not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.


.

copy the file in the xlstart directory. Search for the
xlstart directory to have the full path

-----Original Message-----
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook, not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.
.

Be sure to put this in the ThisWorkbook module

"LD" wrote in message
...
Private Sub Workbook_Open()
Worksheets("Sheet name").Select
End Sub



"Pinda" wrote in message
...
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook, not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.

Thanks mate, do u think you could help me with this, I
posted it ages ago and no one has replied, thanks.

I have a tables of targets with the director
responsible for them against each target (1 director per
target), with an autofilter for the table.

On a separate sheet, I've set up macros linked to buttons
labelled with director's names, so when a director clicks
on his/her own name, it goes to the worksheet of targets
and filters the table to show the targets of that director
only. Here's the code:-


Sub CheSha()
'
' CheSha Macro
' Macro recorded 29/09/2003 by Bhupinder Rayat
'

'
Sheets("LDP Template").Select
ActiveSheet.ShowAllData
Selection.AutoFilter Field:=7, Criteria1:="Chetan Shah"
End Sub

I've recorded the macro to show all data first and then
get the required name. The trouble is when the table is
showing all data already, the macro fails because the show
all data command is not available.

Is it possible to insert an if statement within the above
code to say that if all data is showing
then "ActiveSheet.ShowAllData" does not need to be
performed.

Hope I've explained it sufficiently. Can anyone help?

Thanks in advance.

Pinda

-----Original Message-----
Be sure to put this in the ThisWorkbook module

"LD" wrote in message
...
Private Sub Workbook_Open()
Worksheets("Sheet name").Select
End Sub



"Pinda" wrote in message
...
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to
display a
certain worksheet everytime on opening that workbook,
not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.




.

Create a template
Decide which type of template you want:
Workbook template

Create a workbook that contains the sheets, default text
(such as page headers and column and row labels),
formulas, macros, styles, and other formatting you want
in new workbooks based on the template.

Worksheet template

Create a workbook that contains one worksheet. On the
worksheet, include the formatting, styles, text, and
other information you want to appear on all new sheets of
the same type.

To display a picture of the first page of a template in
the Preview box of the Templates dialog box (General
Templates..., New Workbook task pane), click Properties
on the File menu, click the Summary tab, and then select
the Save preview picture check box.
On the File menu, click Save As.
In the Save as type box, click Template.
In the Save in box, select the folder where you want to
store the template.
To create the default workbook template (default workbook
template: The Book.xlt template that you create to change
the default format of new workbooks. Excel uses the
template to create a blank workbook when you start Excel
or create a new workbook without specifying a template.)
or default worksheet template (default worksheet
template: The Sheet.xlt template that you create to
change the default format of new worksheets. Excel uses
the template to create a blank worksheet when you add a
new worksheet to a workbook.), select either the XLStart
folder or the alternate startup folder (alternate startup
folder: A folder in addition to the XLStart folder that
contains workbooks or other files that you want opened
automatically when you start Excel and templates that you
want available when you create new workbooks.). The
XLStart folder is usually

C:\Program Files\Microsoft Office\Office10\XLStart

To create a custom workbook or worksheet template, select
the Templates folder, which is usually

C:\Documents and Settings\user_name\Application
Data\Microsoft\Templates

Enter the name of the template in the File name box. Do
one of the following:
Workbook template

Type book to create the default workbook template.

To create a custom workbook template, type any valid file
name.

Worksheet template

Type sheet to create a template for default worksheets.

To create a custom sheet template, type any valid file
name.

Click Save, and then click Close on the File menu.

-----Original Message-----
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook,
not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.
.

Pinda

Put the worksheet in the XLSTART directory.

Andy.
"Pinda" wrote in message
...
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook, not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.

Private Sub Workbook_Open()
Worksheets("Sheet name").Select
End Sub



"Pinda" wrote in message
...
On opening a excel workbook, is it possible to have a
default way of opening? For example, I want to display a
certain worksheet everytime on opening that workbook, not
on the worksheet that it was last saved on. Is this
possible?

Hope it makes sense.

Regards.