Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.links
|
|||
|
|||
![]()
I suspect that (since I didn't get any response on my previous request for
assistance) I may need to approach this in stages ... Assuming that Information Rights Management (IRM) won't give me the detailed permissions I need, basically, here's what I need: 1. A Macro that will unprotect a series of Workbooks (approximately 200 of them) so that the Auto Update function in Linked Data can update without user intervention. 2. I copied this Macro from a previous post -- how can I modify the following code to achieve what I need from it: Can I use something like this? I assume that I'll need something like this to unprotect the affected worksheets: ActiveSheet.Unprotect Password:="" '<===I assume that I'll enter my worksheet password between the "" Private Sub Workbook_Open() Dim vLinkSources Dim iLinkSource As Integer vLinkSources = ThisWorkbook.LinkSources(xlExcelLinks) If Not IsEmpty(vLinkSources) Then For iLinkSource = LBound(vLinkSources) To UBound(vLinkSources) ThisWorkbook.UpdateLink vLinkSources(iLinkSource), xlExcelLinks Next End If End Sub I'll need to re-protect the affected worksheets upon closing: ActiveSheet.Protect Password:="" '<===I assume that I'll enter my worksheet password between the "" End Sub Any help in setting me straight on this would be greately appreciated -- thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simplifying my Previous Request for Assistance | Links and Linking in Excel | |||
Simplifying my previous Request for Assistance | Excel Worksheet Functions | |||
Simplifying my previous Request for Assistance | Excel Discussion (Misc queries) | |||
Match Last Occurrence of two numbers and Count to Previous Occurence | Excel Worksheet Functions | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) |