Shared Workbook

Originally Posted by rufusf

Hi.... looking for a bit of help using a shared workbook

I've got a shared workbook set-up which I have 2 or 3 people inputting information into seperatley - it all works fine except for when everyone closes the workbook and then it is re-opened it will be locked to one user (until they select 'Share Woorkbook') - is there any way it will always open up as a shared workbook?

Many Thanks

Hi,

If you record a macro whilst 'Open' and set to 'Share', you will have most of the code to enter into the workbook's open routine.

something like

Please Login or Register  to view this content.

Would this help?

---

Originally Posted by rufusf

Hi Bryan

This is working really well however I'd like to set up the Shared Workbook to also Autosave every 5 minutes (this is one of the advanced options on Shared Workbook) - is this also possible??

many thanks

rufusf

Hi,

That should be covered in the Advanced (as you saw) and in Tools, Options, Save, set to 5 mins.

Once both of these are set for the book they should remain, but the relavant code would be

Please Login or Register  to view this content.

hth
---

Originally Posted by rufusf

Hi Bryan

This has done the trick... many thanks !

rufusf

Good to see, and thanks for the response.
---