• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Fixed path for macros

I have a problem with paths for Excel macros. I have a workbook I need to copy and move. Several people in different departmens are using this so I cannot implement the macros in PERSONAL.XLSB. I need to be able to update them and they have to be part of the sheet. My problem is that although I enter ExcelBook.xlsm!ThisWorkBook.Macro and save it, when I copy/move it and opens it again and try to run the macros, they have changed path to \\server\path\ExcelBook.xlsm!Macro and that doesn't work. I need them to be as I entered them.

Please explain/help!

Iver Erling Arva
Iver Erling Arva
  • 2
1 Solution
This one worked for me
File|Properties|Summary Tab
Set the "hyperlink base"  to C: or D:

Iver Erling ArvaSenior consultantAuthor Commented:
Thanks! That seem to be what I was looking for ;-)

All the best from

IVer in Norway

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now