Results 1 to 2 of 2

Cell selection changing after macro runs to blue hyperlink

Threaded View

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    london england
    MS-Off Ver
    Excel 2010
    Posts
    21

    Cell selection changing after macro runs to blue hyperlink

    Hi everyone,



    Facing an issue with excel, below is some code I use to create a list of tabs and create a fast link back to say a home page within the workbook.



    [/CODE]For Each wSheet In Worksheets
    If wSheet.Name <> Me.Name And wSheet.Visible = xlSheetVisible Then
    n = n + 1
    With wSheet
    .Range("A1").Name = "Start_" & wSheet.Index
    .Hyperlinks.Add anchor:=.Range("A1"), Address:="", _
    SubAddress:="Index", TextToDisplay:="Back to Index"

    End With

    Me.Hyperlinks.Add anchor:=Me.Cells(n, 5), Address:="", _
    SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name
    End If
    Next wSheet[CODE]



    The problem I have is that if I was in sheet one, and I had selected an item from a data validation list, when I go to the tab that fires this macro, as soon as I return to sheet 1 my selection has turned from arial 11 say to calibri 11 blue underscore.



    Its very frustrating, I can code round it by using a sheet activation and selecting all individual cells and forcing them to say Arial 11, but its not the answer to this, and I'm going to start getting code clash.

    It seems like it is changes the style type automatically


    Any help appreciated,



    Simon
    Last edited by margal; 04-26-2018 at 04:05 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro runs quick initially then bogs down after a few runs
    By pongmeister in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2017, 02:02 PM
  2. Sheet Protection Options Changing When Macro Runs
    By jbold in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-25-2013, 10:32 AM
  3. Turn cell A1 blue if any cells between $L$6:$Q$9 are blue
    By sandk0330 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2013, 02:53 PM
  4. Macro runs from Data Validation Drop Down List Selection
    By flindy87 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-28-2013, 11:45 AM
  5. help in changing the code that runs on one cell to the whole column
    By hiteshasrani43 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-07-2012, 10:29 AM
  6. Macro Runs Selection is Made from Validation List
    By jadown in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-08-2011, 03:18 PM
  7. Remove blue hyperlink line
    By Otto Moehrbach in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2006, 12:20 PM

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