Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
to search and display the top 50s (from the previous 14 sheets) in a new sheet | Excel Worksheet Functions | |||
Sum of previous offset number of cells not to exceed certain value | Excel Worksheet Functions | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
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) |