Sharing a workbook

M

Mike

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

..
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shared Workbook Crash 0
Share and protect 1
Running Macros in a Shared File 2
security, enabling macros to enable a disabling saving function 12
Visual Basic in a shared workbook 4
Unwanted workbooks on startup 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Protection Macro Causes All Workbooks to Be Locked 12

Top