Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I share and un-share a workbook using a macro?
I have a excel workbook that I create a barcode picture in and print it. The
information in this workbook is shared by many different users. When a workbook is shared, pictures can not be created. I would like to unshare the workbook, print the barcode, and the share again so that the other users can see infomation created at this station. Can someone tell be how to share and unshare in a macro? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I share and un-share a workbook using a macro?
If ActiveWorkbook.MultiUserEditing Then
ActiveWorkbook.ExclusiveAccess End If If Not ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.FullName, _ accessMode:=xlShared End If -- Cheers Nigel "Botter" wrote in message ... I have a excel workbook that I create a barcode picture in and print it. The information in this workbook is shared by many different users. When a workbook is shared, pictures can not be created. I would like to unshare the workbook, print the barcode, and the share again so that the other users can see infomation created at this station. Can someone tell be how to share and unshare in a macro? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I share and un-share a workbook using a macro?
With ActiveWorkbook
' .KeepChangeHistory = True ' optional .SaveAs Filename:=.FullName, AccessMode:=xlShared .Close End With or If Not ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.SaveAs fileName:=ActiveWorkbook.FullName, _ accessMode:=xlShared End If ----------------------- If ActiveWorkbook.MultiUserEditing Then ActiveWorkbook.ExclusiveAccess End If read the help on these methods. -- Regards, Tom Ogilvy "Botter" wrote: I have a excel workbook that I create a barcode picture in and print it. The information in this workbook is shared by many different users. When a workbook is shared, pictures can not be created. I would like to unshare the workbook, print the barcode, and the share again so that the other users can see infomation created at this station. Can someone tell be how to share and unshare in a macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
share workbook | Excel Discussion (Misc queries) | |||
why can't i share my workbook | Excel Worksheet Functions | |||
Can I share a selfcert macro workbook with other network users | Excel Discussion (Misc queries) | |||
Can't share workbook. The "Share Workbook" option is off. Why? | Excel Discussion (Misc queries) | |||
Can you share a personal macro workbook | Excel Programming |