Good morning everyone. I am in way over my head. and looking for help.....Again. All the other posts on this forum I have seen seem to go the opposite direction. I need a way to copy / update information listed on a master workbook to many other WBs. The master WB will just have regular cell entries (names) All the subsequent WBs (I'll call them minions) will have a sheet that will contain entries identical to the master. So if The master contains the entries in cells A1-A3 **** Jane Spot on sheet 1, the minion WBs will have the same entries in the same cells on the same sheet. I will use the info on sheet 1 to create drop down lists on the minions. I also need to be sure that when new entries are created on the master, the next time the minion is opened it will check and add entries if the master is updated.
From what information I have found, the master must be opened to update the minions. If this is true, The master must be opened, The info updated, and the master closed without the user seeing and / or having access to the master.
There is also coding already in use.
This code is in the "this workbook" section to protect the sheets. I will post the sheet code next. I cannot get both codes on the came post.
From what information I have found, the master must be opened to update the minions. If this is true, The master must be opened, The info updated, and the master closed without the user seeing and / or having access to the master.
There is also coding already in use.
This code is in the "this workbook" section to protect the sheets. I will post the sheet code next. I cannot get both codes on the came post.
VBA Code:
Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In Worksheets
' UserInterfaceOnly:=True allows code to change data.
ws.Protect "green", UserInterfaceOnly:=True, DrawingObjects:=True, _
Contents:=True, Scenarios:=True
Next ws
End Sub
Last edited: