If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
On opening a spreadsheet.
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. . |
#3
|
|||
|
|||
On opening a spreadsheet.
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. . |
#4
|
|||
|
|||
On opening a spreadsheet.
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. |
#5
|
|||
|
|||
On opening a spreadsheet.
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. . |
#6
|
|||
|
|||
On opening a spreadsheet.
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. . |
#7
|
|||
|
|||
On opening a spreadsheet.
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. |
#8
|
|||
|
|||
On opening a spreadsheet.
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. |
Thread Tools | |
Display Modes | |
|
|