Hyperlink to workbook will not open when run as part of macro

**jdutle** · 12-10-2015, 03:21 PM

Hello.

I have a hyperlink to a workbook set to open as part of a macro. When I run the macro the file never opens. Excel just pauses and shows the hourglass and then it goes away. If I click the hyperlink, the linked workbook opens just fine.

If I set the hyperlink to open a word doc and then run the macro it opens the word doc just fine.

Could this be an excel setting?

It has been very frustrating, any help would be appreciated.

The code I used to open the hyperlink is:

Please Login or Register  to view this content.

**davesexcel** · 12-11-2015, 02:25 AM

Please edit your original post and add code tags to the code.

AA CodeTags.jpg

**jdutle** · 12-11-2015, 10:26 AM

It seems to just highlight rows based on the number of rows of data there are in column A

**davesexcel** · 12-11-2015, 09:21 PM

Originally Posted by jdutle

It seems to just highlight rows based on the number of rows of data there are in column A

Yep..... but I was showing you how to edit your post to add code tags to your code.

**jdutle** · 12-12-2015, 10:48 AM

Originally Posted by davesexcel

Yep..... but I was showing you how to edit your post to add code tags to your code.

Duh, I'm sorry. I'm new to this. I know now for next time. Thanks!

**davesexcel** · 12-12-2015, 11:27 AM

Originally Posted by jdutle

...I know now for next time......!

You should still be able to edit it.

**jdutle** · 12-15-2015, 06:19 PM

Got it Thanks!

**davesexcel** · 12-15-2015, 07:05 PM

Possibly

Please Login or Register  to view this content.

**jdutle** · 12-16-2015, 10:42 AM

Darn no luck. It brought open the dialog box about making sure the link is from a trustworthy source, but when I click ok it does the same thing. The hour glass comes up excel pauses for a second and then nothing.

If I click the hyperlink, the same dialog box comes up, I click ok and then the file opens.

It makes no sense. The macro is taking place of acutally clickin the link, it should do the same thing, but doesnt

**davesexcel** · 12-17-2015, 08:50 AM

Could you just use VBA to open the workbook instead of using a hyperlink?

**jdutle** · 12-17-2015, 10:29 AM

Technically yes, but I dont think it would be very user friendly to have to create a vba for each link. I have a summary sheet that have hyperlinks to many individual workbooks. They hyperlinks were meant to be an easy way for users to open and edit the individual workbooks. I was trying to keep them from having to find the file each time they wanted to open it.

**davesexcel** · 12-18-2015, 02:27 AM

Why would the user have to select a file, could they not just open the file they click on?

**davesexcel** · 12-18-2015, 02:49 AM

Do a web search on Removing Hyperlink Warnings, you will not be pleased with the results.

Here is one solution.

Remove the hyperlink , then use selection event to open the workbooks.
The code goes into the worksheet module.

RightClick.jpg

This code does all that, you can also select the column then right click and select "Remove Hyperlinks"

12-18-2015 1-17-00 AM.jpg

Please Login or Register  to view this content.

**jdutle** · 12-18-2015, 11:05 AM

I was wanting to use the hyperlink so they would not have go in to the browswer to open the file, or do a file open.

I did find a glimmer of hope. While in the VB editor, if I click the pause/break button, then hit resume, the macro will run just fine. It only work if I run it in VB, I tried to map the macro to a button after it was working, but outside of VB it behaves the same as before. Have you ever heard of anything like that? I did some searching, but couldn't find a conclusive answer.

**davesexcel** · 12-18-2015, 11:20 PM

My last post shows you how to do it, you just have to click the cell and it will open the workbook.

Hyperlink to workbook will not open when run as part of macro

LinkBack

Thread Tools

Rate This Thread

Display

Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Re: Hyperlink to workbook will not open when run as part of macro

Thread Information

Users Browsing this Thread

Similar Threads

macro to open files and copy specific sheet into new workbook (have open files part)

Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls) (Part 2)

hyperlink to open workbook read only

Macro to replace part of hyperlink (New Request)

hyperlink wants to reopen already open workbook

Macro to replace part of hyperlink

Hyperlink To Open Workbook and Particular Tab (Sheet)..Possible?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions