If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Simplifying my previous Request for Assistance
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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Meeting request | Olivier | Calendar | 0 | December 7th, 2004 12:55 PM |
Meeting Request appearing in calendar | ddt | General Discussion | 0 | August 25th, 2004 07:14 AM |
Outlook 2002 - meeting request forwarding problem | Derek | Calendar | 0 | June 9th, 2004 02:55 PM |
Meeting Request Compatibility: Outlook 2003 vs 2000 | Ian | Calendar | 1 | June 7th, 2004 08:02 PM |
FW: iCalendar request performs differently in outlook 2002 than outlook 2003 | Aguila_Eagle | Calendar | 0 | June 6th, 2004 01:43 PM |