Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cursor movement & Command Buttons (Excel 2002)

    While working in some worksheets I need the cursor to remain in the same cell after pressing the

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor movement & Command Buttons (Excel 2002)

    To stop the cursor from moving to a new cell after you press enter select Options from the Tools menu. In the resulting dialog box click on the Edit tab. Remove the check mark next to "Move selection after Enter".

    What control are you trying to add to the worksheet? It sounds like you are trying to add one that came with Microsoft Map that is no longer supported.
    Legare Coleman

  3. #3
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor movement & Command Buttons (Excel 2002)

    Thanks for answering the cursor question. I am trying to add a page print macro button onto the specific page.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Cursor movement & Command Buttons (Excel 2002)

    I am not sure either what problem you are describing and what macro button you are trying to add. What is it supposed to do? If you want to add a button to print the current sheet, you could just add the command button and add code to print the activesheet (or anything else you like)

    <pre>Sub PrintSheet()
    ActiveSheet.PrintOut
    End Sub</pre>


    Steve

  5. #5
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor movement & Command Buttons (Excel 2002)

    When I follow the instructions in your first message, I don't see any "page print macro button" in the available controls. Do you have a macro that you are trying to assign to a control? If so, which control? Can you tell us exactly what you do to get the message?
    Legare Coleman

  6. #6
    New Lounger
    Join Date
    Mar 2004
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cursor movement & Command Buttons (Excel 2002)

    I thank all that have responded to my questions. I will try the print macro that Steve has suggested. I have an Excel program for trading options created by Jesse Chan (www.OptionsStar.com) that I think is a fantastic piece of Excel programming. I am trying to emulate the way he uses some some of the features to my spreadsheets.
    Thanks again!
    CEJ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •