Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with the first sheet to be automated.
Hi,
In every first of excel the cover sheet message should be inputted. whenever I open the excel file automatically the first sheet should contain the cover sheet information always. Could you please guide how to automate this when ever I open the spreadsheet the first sheet should be with the cover sheet information. Regards, Igneshwara reddy. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with the first sheet to be automated.
Hi
Use the following workbook open event Private Sub Workbook_Open() ThisWorkbook.Sheets("Cover Sheet").Select End Sub Copy the code above Press Alt+F11 to open the Visual Basic Editor In the left explore pane, double click This Workbook paste the code into the large white pane that appears Press Alt+F11 to return to Excel. Save the Workbook and close. When you open, it will open at the sheet called "Cover Page" Change Cover Page in the code to whatever your sheet is called. -- Regards Roger Govier "Igneshwara reddy" wrote in message ... Hi, In every first of excel the cover sheet message should be inputted. whenever I open the excel file automatically the first sheet should contain the cover sheet information always. Could you please guide how to automate this when ever I open the spreadsheet the first sheet should be with the cover sheet information. Regards, Igneshwara reddy. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with the first sheet to be automated.
Hi,
This was not I was expecting the solution. I having a coding which I have done the macros to run for my work, now whenever I open any spreadsheet (not specific) the cursor has to move extreme left (irrespective of the sheets it has and wherever the cursor is) and it has to insert a sheet. There onwards it has to rename the sheet as "Verson" and my macros should run in that spreadsheet. Let me know how it can be done. Regards, Igneshwara reddy. "Roger Govier" wrote: Hi Use the following workbook open event Private Sub Workbook_Open() ThisWorkbook.Sheets("Cover Sheet").Select End Sub Copy the code above Press Alt+F11 to open the Visual Basic Editor In the left explore pane, double click This Workbook paste the code into the large white pane that appears Press Alt+F11 to return to Excel. Save the Workbook and close. When you open, it will open at the sheet called "Cover Page" Change Cover Page in the code to whatever your sheet is called. -- Regards Roger Govier "Igneshwara reddy" wrote in message ... Hi, In every first of excel the cover sheet message should be inputted. whenever I open the excel file automatically the first sheet should contain the cover sheet information always. Could you please guide how to automate this when ever I open the spreadsheet the first sheet should be with the cover sheet information. Regards, Igneshwara reddy. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated Timecard | Excel Discussion (Misc queries) | |||
Run automated macros | Excel Discussion (Misc queries) | |||
Automated Footer | Excel Discussion (Misc queries) | |||
Automated Archiving | Excel Discussion (Misc queries) | |||
Automated Hyperlinking | Excel Worksheet Functions |