Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA coding to go to cell not working (2000)

    For some reason the VBA coding to go to a cell automatically when the spreadsheet loads up is not working.
    See attachment for coding.

    Any help would be appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA coding to go to cell not working (2000)

    You have nested the Workbook_Open procedure within the Worksheet_Activate procedure. This is not valid for two reasons:
    - You cannot ever nest one procedure within another one.
    - The Workbook_Open procedure belongs in the ThisWorkbook module, not in the Sheet1 module.

  3. #3
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA coding to go to cell not working (2000)

    How do l access the Thisworkbook module?

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA coding to go to cell not working (2000)

    <P ID="edit" class=small>(Edited by Jezza on 07-Apr-06 14:22. To correct typo)</P>In the VB Editor click View| Project Explorer or Ctrl+R

    This will open a panel where you can view the Excel Objects, one of these will be the ThisWorkbook, double click on it.
    Jerry

  5. #5
    5 Star Lounger
    Join Date
    Mar 2004
    Posts
    924
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA coding to go to cell not working (2000)

    Thats great , may thanks for that.

Posting Permissions

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