+ Reply to Thread
Results 1 to 3 of 3

Hyperlink to _blank

Hybrid View

aaaaaaa Hyperlink to _blank 07-13-2007, 03:15 AM
aaaaaaa Hyperlink to _blank 07-13-2007, 03:18 AM
aaaaaaa Bump 08-01-2007, 09:16 PM
  1. #1
    Registered User
    Join Date
    07-13-2007
    Posts
    13

    Hyperlink to _blank

    I want to insert a hyperlink into Excel that will open the webpage as a blank when my Excel file is saved as HTML. Right now, when my Excel file is saved as HTML and I click on the hyperlink, it opens the page in the _parent page, navigating me away from my spreadsheet. In HTML code, I would simply insert target="_blank" in to the href code. I currently have all my hlinks coded with =hyperlink() in each cell instead of using the wizard. Any suggestions?

  2. #2
    Registered User
    Join Date
    07-13-2007
    Posts
    13

    Hyperlink to _blank

    I'm not great with VBA, so would prefer to avoid it if possible. However, if it's my only choice, I just ask for specific instructions. Thanks.
    Last edited by aaaaaaa; 07-13-2007 at 04:50 AM.

  3. #3
    Registered User
    Join Date
    07-13-2007
    Posts
    13

    Bump

    Reposted. I take it nobody can figure out this one? Again, when I save the file as a web page and open that web page, the hyperlinks open in the parent page, meaning it navigates away from the Excel spreadsheet. I want the hyperlink to open a target, or new, browser window. I can't rely on IE settings because many people use this spreadsheet. I need it in the coding somehow. I'm currently using the =HYPERLINK formula, instead of the wizard.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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