Hi All

Sorry! I am in need of your help

I am trying to create a macro in VBA to share a workbook automatically when
the workbook is opened.

I tried recording a macro and using the data from that but when run, before
it shares the workbook, it state the file already exists, do you want to
replace this file.

I need it share the worksheet without asking any questions

Hope you can help

Thanks

Mike

..

Who!!! the brain do work some times

I have achieved this but am left with another problem.

Does anyone know how to get around some of the blocked access in a shared
file like un-protecting a file and still keeping it shared

Thanks in advance

Mike


Mike wrote in message
. uk...
Hi All

Sorry! I am in need of your help

I am trying to create a macro in VBA to share a workbook automatically
when
the workbook is opened.

I tried recording a macro and using the data from that but when run,
before
it shares the workbook, it state the file already exists, do you want to
replace this file.

I need it share the worksheet without asking any questions

Hope you can help

Thanks

Mike

.