| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Links and users
I have a workbook that links to three external workbooks. I'd like to create
a userform where the user could just enter the correct file name (without having to go to the drop down menus from the tool bar). Is there a way to do this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Links and users
Look at the ChangeLink method and the LinkSources in Excel VBA help.
-- Regards, Tom Ogilvy "Joyce" wrote in message ... I have a workbook that links to three external workbooks. I'd like to create a userform where the user could just enter the correct file name (without having to go to the drop down menus from the tool bar). Is there a way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sharing excel sheet with multiple users, but other users cant see | Excel Discussion (Misc queries) | |||
| How do I ensure that users are prompted to update links at start | Excel Discussion (Misc queries) | |||
| How do I allow users to edit links in a protected worksheet? | Excel Worksheet Functions | |||
| prevent users from overwriting other users data | Excel Worksheet Functions | |||
| Help - Automating a file.. Adding Users , Deleting users, Changing | Excel Worksheet Functions | |||
Linear Mode
