Help with the first sheet to be automated.

[Igneshwara reddy]

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.

 

[Roger Govier]

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.

 

[Igneshwara reddy]

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.