Macro to Open Edit Links Pop Up - Building single drive workflows (some peeps using 6 different drives)

[lifecraftmedia]

I would like a macro to open the edit links Pop-up screen, and require the file user to close it.

Trying to record the macro, the code generator creates a code that causes the pop-up to close. I want it to stay open so file users have to see the links pop-up, and recognize when they have files that are getting crazy - I was working in and excel file yesterday that accessed 6 different physical drives - ah...

Simple idea, open the pop-up, and then what I would like to do with it, is place it in my staff's personal macro workbook, to be run when any excel file with links opens (at least until we get down to two active physical drives, or even one! (These are backed up servers, but why use six?)

 

[Jeffrey Mahoney]

How about this?

Application.Dialogs(xlDialogOpenLinks).Show

Welcome to the site!

Jeff

 

[Jeffrey Mahoney]

If you want it to open when the user opens the workbook, you'll need to add this sub:

Private Sub Workbook_Open()  
   [COLOR=#574123]Application.Dialogs(xlDialogOpenLinks).Show[/COLOR]
  
End Sub

This gos into the "ThisWorkBook" section

 

[lifecraftmedia]

Thanks Jeffery - got it! Working on an error routine so I can put it in a xlsm template (tested in a file without links, it goes to debug error popup).

I spend many years developing desktop workflows as a corporate accountant type - mostly analytical until 8 years ago when I was moved into a VP management position - and for eight years I have not been active in the automation end of Excel - a bit perhaps, but not like in the ODCB extract, process, output to the next system days - I started with Supercalc, then Lotus 123, 1.2 on a IBM 8086, serial number 000093, and my favorite old keyboard macros...