Hi,
Please use the following code:
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
Cheers!
Andy
On Thu, Sep 2, 2010 at 9:58 AM, big smile bigsmile...@gmail.com wrote:
Respected Excel Guru's
How to make the macro so that
When ever i start the file my
C P SAVLA
You don't need a macro for this, just make sure that the cell is selected
when you save the file and it will open in the same cell when you next open
the file...
Kind regards
Michael
UK
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On
Sir.
Thanks for your fast reply.
I have put this in View Code. -- but stil it does not work until i press run
in view code.
I have another function also in that as follows
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
Cancel = True
Hi,
1. You need to press Alt+F11, and open the visual basic editor.
2. Double click on This Workbook
3. Paste the code.
*Private Sub Workbook_Open()*
Sheets(Sheet2).Select
Range(A494).Select
*End Sub*
4. Save the file (For XL 2003 as .xls , or for XL 2007 as .xlsm)
5. Close the file and try to