I have linked 2 workbooks......
Obviously 1st one has to be opened before the 2nd one to allow for updating......
If a user attempts to open the 2nd one first is it possible to prevent it or open the 1st one automatically?
I get complaints that the linking doesn't work........ but its because others don't know how to use excel!!
In what way have you linked them? Via formulae?
What you are describing will probably require VBA coding - are you able to run macro-enabled workbooks on your work network?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yes
Basically in workbook 2 in cell A1 =A1workbook1
Yes I have a vba code running to extract Cell Comments which is useful.
Without seeing the workbook and code, I don't think we are going to get very far.
Cant share the workbooks.....GDPR policy....got names addresses etc on them.....
Ok never mind it was more of a general question anyway.
Thank you
You do not need to share sensitive information, and that's not what we are asking. You can share a dummy workbook and the VBA code. There are so many different approaches - we would need to understand your set-up, so no, it's not really a general question because there isn't a one-size-fits-all answer.
ok so made up an example based on the rota.
Sheet2 is linked to sheet1
Id like to see the Blue Cell colour as per sheet 1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks