Actually, the code belongs in a General module.

Select your project in the VBE's project explorer.
Then Insert|module.
Then paste there.

But if you actually ran that code (F5 or Run|Run Sub from within the VBE), it
should have worked ok.

How did you run the code (well, if you did run the code)?

And if it still doesn't work, you still may want to paste your code. (Remember
that you have to match case or code around it.)


Dede wrote:

I am starting to think maybe I have my code in the wrong place. When I open
the sheet and do Alt+F11. I double-click on "This Workbook" on the left hand
side. This opened a window that has a drop-down for "General" and "Workbook"
and I tried running the code in both places.

Am I putting the code in the wrong place?

"David McRitchie" wrote:

Hi Dede,
and what you see with Ctrl+K (insert hyperlink) for the
Type the file or Web page name:
Text to display:
ScreenTip: (if not empty)
also what you see on the formula bar if not the same as Text to display

The slashes or periods added would not make it work if it is not working
-- that suggestion was just to prevent you from making inadvertent changes.

To make sure you installed in correct place include this line of code
Msgbox "installed correctly, now what?"
You should be running as standalone from Alt+F8 to invoke macro
and there should only be one macro with that name shown.

Can't imagine that you would have anything in the following, unless you
inherited the workbook, but check anyway.
file, properties, summary, hyperlink base:

http://www.mvps.org/dmcritchie/excel...#FixHyperlinks


"Dave Peterson" wrote ...
You may want to post your code.

Dede wrote:
I changed the code again and added the slashes but the hyperlink still does
not change when I run the macro.






--

Dave Peterson