Who has read/write

[John Pritchard]

Hi there,

If I open a workbook with workbooks.open I can tell if
it's been opened as readonly which is fine BUT can I also
find out who currenly has it open for read/write in VB ? -
If not is there a way of adding a property to a workbook
so that I can record who has a book open for read/write ?

 

[Anne Troy]

Perhaps you need something like this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=33

Or perhaps you can just take some of the code from it.

________________________

**** Hope it helps! ****

~Dreamboat
Finally! Excel VBA Certification
www.VBAExpress.com/training/
********************************

 

[John Pritchard]

Thanks Anne well done on the Certificate!

-----Original Message-----
Perhaps you need something like this:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=33

Or perhaps you can just take some of the code from it.

________________________

**** Hope it helps! ****

~Dreamboat
Finally! Excel VBA Certification
www.VBAExpress.com/training/
********************************


read/write ?


.

 

[Anne Troy]

Oh, I don't have a cert, John. But our website will be offering Certs VERY
soon. (Changed my signature a bit...)
________________________

**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
********************************