Share workbook macro

cgmojoco

Well-known Member
Joined
Jan 15, 2005
Messages
696
I tried recording the script that shares a workbook to no avail.

What is the script for sharing a workbook?

Specifically, I'd like to share the workbook with "Don't keep change history" selected.

And uncheck Include in personal view print settings and filter settings.

All of these are options when you manually share a workbook...

Thanks in advance!
Christopher
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

cgmojoco

Well-known Member
Joined
Jan 15, 2005
Messages
696
This got me at least part way there

;)

Code:
'SHARE
Sub Sharing()
Dim CurFilename As String
Dim CurPath As String
Dim CurFile As Variant
Application.DisplayAlerts = False
ActiveWorkbook.ProtectSharing Filename:=ActiveWorkbook.FullName
Application.DisplayAlerts = True
End Sub
 

cgmojoco

Well-known Member
Joined
Jan 15, 2005
Messages
696
Can anyone get me the rest of the way?

I need to at least have the macro set the setting to save every X number of minutes.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,536
Messages
5,572,767
Members
412,482
Latest member
arooshrana2
Top