| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit Links: Changing links on a protected worksheet
I wish to protect a worksheet but allow the user to Edit Links and change the
source of exiting external links to excel workbooks. So far i have been unsuccessful. Is it possible to call the menu item Edit Links... from visual basic for applications? The ChangeLink method is not dynamic in that its requires that one knows the string or name of the new link. Ideally I would like the user to use the window displayed by the Edit Links... menu item. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I unprotect a text box in an otherwise protected worksheet | Excel Discussion (Misc queries) | |||
| Edit specific range in protected worksheet | New Users to Excel | |||
| Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
| Insert comment in protected worksheet | Excel Worksheet Functions | |||
| Edit Links: make update manual | Excel Discussion (Misc queries) | |||
Linear Mode
