Hi,

I'm new . I started using vba only last monday because I have to find a solution on the below. Also, English is not my native language so excuse me for grammar and spelling mistakes .

I have made 15 workbooks who are all shared, sheets are protected, and they all have links to eachother. (Well to be completely correct: 7 sheets are an overview with links from the 8 other sheets, these 8 also have links from the overviews but not to eachother).These are all used by multiple persons who can have multiple sheets open.

So, to start, I added code to save each sheet every time a cell is changed. I have added following vba to ThisWorkbook on each workbook:
Please Login or Register  to view this content.
This works, but my question is: would it be possible to create a checkbutton to switch this off an on again as pleased? (it should be on when workbook is openen).

Then my 2nd question:

In all sheets I have added a button with following vba to update the links. As you can not update links in a protected sheet, I created on each workbook an unprotected sheet ("update") to go to, so links can be updated. And then go back to the previous sheet. However at first I had an issue when multiple workbooks were open, so after some googling and copy pasting different pieces of vba together I came with the following solution:

Please Login or Register  to view this content.
Note that for each workbook (and different sheets on those workbooks) I make small adjustements to the name of the sub because otherwise they conflict when I have multiple workbooks open.This also works. But I have 1 issue left with this:When I update the links while I have an other workbook open (were the links are connected to), and another user already added something, then I can not see that change because I first need to save the other workbook.Could anyone help me or point me the way to add vba to safe the other workbooks that are open first so all changes are showing after refreshing the values?

And my last question, also for this last vba, how can a add a shortcut? I have tried already, but when I have multiple workbooks open it conflicts because I want to use the same shortcut for each button. Also, on some workbooks I have multiple sheets with this button (on those I have added a line to above vba to redirect to the correct sheet after updating).

Thanks!