Bring 'Edit Links'

[dluhut]

Hi Excel VBA gurus,

I created a workbook where I protect the sheets.

Because the sheets are protected, whenever user wants to update links, especially specific links, it is being greyed out.

In order for user to be able to update links, one of the sheet need to be unprotected. In that unprotected sheet, user can go to Data\Edit Links to have do whatever user wants on the 'Edit Links' window.

I'm thinking of creating a macro where when user click on an icon, it'll automatically brings out the 'Edit Links' window PREFERABLY while the sheets are still protected.

However, if it's not possible, then the way is basically
1.) Unprotect the sheet
2.) Bring up the 'Edit Links' window
3.) When user click on 'Close' button or the '[X]' icon at the upper right, protect sheet

My question is, how do I bring out the 'Edit Links' window

[maurithegreat]

Add the following line of code to your VBA:

Please Login or Register  to view this content.