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 open it.
This should run the code.
NOTE: The macro might not run in case the macro security is set to High. You
have to lower the Macro Security to make it work.
Please let me know if you need any further help on this.
Regards,
Aindril
On Thu, Sep 2, 2010 at 6:10 PM, big smile <bigsmile...@gmail.com> wrote:
> 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
> Target.EntireRow.Insert
> End Sub
>
> due to which the problem comes
>
> Whenever i close my cursor is for Ex. on A392 & but whenever i reopen
> this file
>
> it should be on ex. A494.
>
>
> One more thing the soultion given by Michael Brumby that i know sir Then
> also thanks for the answer.
>
> Thanks
>
> Have a nice day
> CP SAVLA
>
>
>
>
>
>
> On Thu, Sep 2, 2010 at 1:05 PM, Aindril De <aind...@gmail.com> wrote:
>
>> 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 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 nice day.
>>>
>>> C P SAVLA
>>>
>>> --
>>>
>>> ----------------------------------------------------------------------------------
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 7000 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
