Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Major help needed!!!
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Major help needed!!!
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Major help needed!!!
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Major help needed | Excel Discussion (Misc queries) | |||
Need some major help | Excel Discussion (Misc queries) | |||
Major Help Needed Asap | Excel Worksheet Functions | |||
Range - Offset (Major help needed) | Excel Programming | |||
Major help needed | Excel Discussion (Misc queries) |