+ Reply to Thread
Results 1 to 9 of 9

Worksheet edit links

  1. #1
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Worksheet edit links

    Hello
    When I press any key in an open worksheet or open a new worksheet there's a worksheet that opens automatically.

    I checked the worksheet that open automatically but the to edit or break the links are in grey colored.

    Is there a reason why is doing this?
    If so, please tell what I need to do.
    Thank you.

  2. #2
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Worksheet edit links

    I think I figured it out what is the reason.
    When I took this code out from the VBA, it does not do the issue.

    How do I keep this code in it? I need this code so I can keep my tab in order.

    Thanks in advance.


    ThisWorkbook VBA:
    Please Login or Register  to view this content.

    Module1:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Worksheet edit links

    Delete red lines of code and try again:

    Please Login or Register  to view this content.
    Tuomas "Banaanas" Savonius
    Trying to give back now when I actually can do some VBA

  4. #4
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Worksheet edit links

    I did remove it but still doing the same.
    :O(

  5. #5
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Worksheet edit links

    can you attach your workbook and a picture of what is happening that you want to stop?

  6. #6
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Worksheet edit links

    Hi Banaanas
    Now I think its between the button code for EXIT and the TAB ORDER codes are affecting each other.

    Here is the attachments.

    Thank you
    Attached Files Attached Files

  7. #7
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Worksheet edit links

    Try to open a new blank worksheet.
    Now, open the attachment I sent you. Click the Button Exit.
    In the open blank worksheet, press tab key and it will open the worksheet with the button key.

  8. #8
    Forum Contributor banaanas's Avatar
    Join Date
    08-26-2014
    Location
    Finland
    MS-Off Ver
    2016
    Posts
    199

    Re: Worksheet edit links

    I didn't understand what your problem is. It does exactly what you described in the last post. What is the problem? :D

  9. #9
    Forum Contributor
    Join Date
    10-05-2014
    Location
    CALIFORNIA
    MS-Off Ver
    2010
    Posts
    1,719

    Re: Worksheet edit links

    Hi
    I believed that the exit button vba code and the other codes are affecting each other.
    If I don't use the exit button and use the proper exit it does not do the issue.

    Let me try to explain. Let say you have 2 open workbook including the one that I have an issue with. Close the workbook that I have an issue with and when you close it, use the button exit. Now, go to the other workbook and try to hit the tab key and it will open the one that I have an issue with automatically.

    thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Edit Links - Break Links not working
    By dmang1 in forum Excel General
    Replies: 10
    Last Post: 03-16-2017, 12:43 PM
  2. Edit edit links macro to automate sheet selection
    By sds1126 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2015, 12:27 PM
  3. [SOLVED] Edit links to external worksheet
    By myobreportguru in forum Excel General
    Replies: 24
    Last Post: 03-18-2013, 11:48 PM
  4. Edit Links Alert Message but no links
    By ericad in forum Excel General
    Replies: 0
    Last Post: 12-22-2011, 11:41 AM
  5. Worksheet Protection and Edit Links
    By jholmstrom21 in forum Excel General
    Replies: 1
    Last Post: 10-24-2011, 12:28 AM
  6. Edit Links When New Worksheet Added
    By jimbean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-02-2008, 08:38 AM
  7. Edit Links: Changing links on a protected worksheet
    By Halibut68 in forum Excel General
    Replies: 0
    Last Post: 04-28-2006, 06:10 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1