| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Call the edit-links dialog box
I have a workbook with protected sheets. I don't want users to be able to
edit the formulas generally. But, several formulas have external links that I would like the users to be able to point at different files. The problem is, if the cells with the links are locked, the "change source" button in the edit links dialog box is disabled. I can see one of two solutions: 1) I need either an event for when the edit links dialog box is opened that will enable me to unprotect the sheets, and an event to protect the sheets when the dialog box is closed. 2) Create a proc. that will unprotect the sheets, call the edit links dialog box, and then protect the sheets Can anyone help? Thanks Chris -- Chris Farkas Excel/Access Developer http://www.eAlchemy.biz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Links Dialog Box too long to view contents | Links and Linking in Excel | |||
| Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
| Call the Save As dialog | Excel Programming | |||
| Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
| Edit=Links dialog box-use code to display | Excel Programming | |||
Linear Mode
