Help to the first sheet

  • Thread starter Thread starter Igneshwara reddy
  • Start date Start date
I

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.
 
In the VB Editor there is a module at the bottom of the list of sheets that
is called ThisWorkbook. Click on it and insert the following code

Private Sub Workbook_Open()
Sheets("MyFirstSheet").Activate
End Sub

Change "MyFirstSheet" to the name of your first worksheet --keeping the
quotation marks.
 
Hi,

I hope you have not understood my requirement, apologize for that.

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.
 
OK Let's take this one step at a time

1.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)
Try this
'Move to the left 10 "screen widths"
ActiveWindow.LargeScroll (ToLeft:=10)


2. and it has to insert a sheet. There onwards it has to rename the sheet
as "Verson"

Worksheets.Add
Activesheet.Name="Verson"



and my macros should run in that spreadsheet.

You can make things happen in this worksheet by starting with:

With Sheets("Verson")
.Activate
.Cells(3,7).Select
Etc
End With
 
Hi Cush,

The information was helpful but I am receiving an error when I am using

ActiveWindow.LargeScroll (ToLeft:=10)

Compile Error:
Expected:=


Not able to understand what is this referring too..

Please guide me on this.

Regards,
Igneshwara reddy.
 
Back
Top