Hi all,
I have a user that wants the Change Links dialog to show at the press of a button, but I can't get it to work. This format of code:
works for all kinds of things, but not the Change Link one, I'd imagine it's because you should have to specify the "From" link to get to the dialog. But how to? What's the syntax?
After searching the web for 2 hours for info on this particular built-in dialog, thought I'd ask here. Has anyone done this?
I don't need a workaround, I can see a couple of ways around this. I am curious as to how you get this working.
This is Excel 97 ( I know, I know, soooo outdated. But it's what the client uses. ).
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
I have a user that wants the Change Links dialog to show at the press of a button, but I can't get it to work. This format of code:
Code:
Application.Dialogs(xlDialogChangeLink).Show
After searching the web for 2 hours for info on this particular built-in dialog, thought I'd ask here. Has anyone done this?
I don't need a workaround, I can see a couple of ways around this. I am curious as to how you get this working.
This is Excel 97 ( I know, I know, soooo outdated. But it's what the client uses. ).
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.