Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,041
- Office Version
- 365
- Platform
- Windows
Hello folks,
I have a number of workbooks that are shared and this works well.
However, some of these workbooks contain data links and I would like to know if it is possible to write a macro and assign it to a command button so that each user, on opening the workbook can click on the button an update links (otherwise they just might forget!). In some cases there are data links to two sheets that require updating.
Mel
I have a number of workbooks that are shared and this works well.
However, some of these workbooks contain data links and I would like to know if it is possible to write a macro and assign it to a command button so that each user, on opening the workbook can click on the button an update links (otherwise they just might forget!). In some cases there are data links to two sheets that require updating.
Mel
