Respected Excel Guru's
How to make the macro so that
When ever i start the file my cursor goes into that particular cell only.
For EX. Sheet 2 - A494 etc.
The purpose behing this is ex. i have set the target of achieving certain
amount -- so how much
still pending to achieve.
Thanks have a
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
]
On Behalf Of big smile
Sent: 02 September 2010 05:28
To: EXCEL MACRO GROUP
Subject: $$Excel-Macros$$ CURSOR GOES TO PARTICULAR CELL WHEN I START THE
FILE
Respected Excel Guru's
How to make the macro so that
When ever i start the file my cursor goes into that particular cell only.
For EX. Sheet
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