Ok, here's my issue... I have 5 workbooks that users fill out. Each of these
5 workbooks are linked to a master workbook which holds employee salary
information. So when I open the 5 workbooks I can't choose to update links
because the master workbook is password protected.

Hope I haven't lost you... In the master workbook I wrote a close event that
would open each of the 5 workbooks (which would update the information) then
save and close them. This works great.

To make matters more complicated, there are 6 & 7th workbooks. Information
from the 5 workbooks flows into sheets in both workbooks and information from
various sheets in workbook 6 flows into workbook 7.

There is a summary sheet in workbook 6 that takes the information gathered
in the other sheets of workbook 6 and the one sheet in workbook 7 and sums it
all up nice and pretty.

(If your wondering why I split it up this way, my manager told me to do
it... I used to have 6 & 7 in one workbook but it was over 10,000kb and
couldn't be uploaded to sharepoint.)

I have coded it so that when one of the first 5 workbooks are closed the
code will open workbooks 6 & 7, save and close them (to update the values).
So far so good...

My issue is that when I open workbook 6 it updates 7, but then 7 needs to in
turn update the summary tab in workbook 6. All of the workbooks are linked to
the Master workbook in some way shape or form. So I can't have the users just
choose to update the links (remember master workbook is password protected
and users can't have the password)...

Maybe I'm way overthinking this... I've just started learning VBA so any and
all assistance is appreciated!!!!

Thanks so much!

Not sure if this will help, but it is an idea. You could protect the sheets
in your workbooks using code like this:

Sheets("Sheet1").Protect UserInterfaceOnly:=True

This will protect the sheets in such a way that only macros can make changes.

Hope this helps.
--
Cheers,
Ryan


"ChrisP" wrote:

Ok, here's my issue... I have 5 workbooks that users fill out. Each of these
5 workbooks are linked to a master workbook which holds employee salary
information. So when I open the 5 workbooks I can't choose to update links
because the master workbook is password protected.

Hope I haven't lost you... In the master workbook I wrote a close event that
would open each of the 5 workbooks (which would update the information) then
save and close them. This works great.

To make matters more complicated, there are 6 & 7th workbooks. Information
from the 5 workbooks flows into sheets in both workbooks and information from
various sheets in workbook 6 flows into workbook 7.

There is a summary sheet in workbook 6 that takes the information gathered
in the other sheets of workbook 6 and the one sheet in workbook 7 and sums it
all up nice and pretty.

(If your wondering why I split it up this way, my manager told me to do
it... I used to have 6 & 7 in one workbook but it was over 10,000kb and
couldn't be uploaded to sharepoint.)

I have coded it so that when one of the first 5 workbooks are closed the
code will open workbooks 6 & 7, save and close them (to update the values).
So far so good...

My issue is that when I open workbook 6 it updates 7, but then 7 needs to in
turn update the summary tab in workbook 6. All of the workbooks are linked to
the Master workbook in some way shape or form. So I can't have the users just
choose to update the links (remember master workbook is password protected
and users can't have the password)...

Maybe I'm way overthinking this... I've just started learning VBA so any and
all assistance is appreciated!!!!

Thanks so much!

I don't think I can use this for my issue, but it's very nice information to
have. Thanks so much!!!

"RyanH" wrote:

Not sure if this will help, but it is an idea. You could protect the sheets
in your workbooks using code like this:

Sheets("Sheet1").Protect UserInterfaceOnly:=True

This will protect the sheets in such a way that only macros can make changes.

Hope this helps.
--
Cheers,
Ryan


"ChrisP" wrote:

Ok, here's my issue... I have 5 workbooks that users fill out. Each of these
5 workbooks are linked to a master workbook which holds employee salary
information. So when I open the 5 workbooks I can't choose to update links
because the master workbook is password protected.

Hope I haven't lost you... In the master workbook I wrote a close event that
would open each of the 5 workbooks (which would update the information) then
save and close them. This works great.

To make matters more complicated, there are 6 & 7th workbooks. Information
from the 5 workbooks flows into sheets in both workbooks and information from
various sheets in workbook 6 flows into workbook 7.

There is a summary sheet in workbook 6 that takes the information gathered
in the other sheets of workbook 6 and the one sheet in workbook 7 and sums it
all up nice and pretty.

(If your wondering why I split it up this way, my manager told me to do
it... I used to have 6 & 7 in one workbook but it was over 10,000kb and
couldn't be uploaded to sharepoint.)

I have coded it so that when one of the first 5 workbooks are closed the
code will open workbooks 6 & 7, save and close them (to update the values).
So far so good...

My issue is that when I open workbook 6 it updates 7, but then 7 needs to in
turn update the summary tab in workbook 6. All of the workbooks are linked to
the Master workbook in some way shape or form. So I can't have the users just
choose to update the links (remember master workbook is password protected
and users can't have the password)...

Maybe I'm way overthinking this... I've just started learning VBA so any and
all assistance is appreciated!!!!

Thanks so much!