Re: $$Excel-Macros$$ sharing of excel workbook

Try this: If ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.ExclusiveAccess End If Insert your code here If Not ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.saveas Act

Re: $$Excel-Macros$$ sharing of excel workbook

Try this: Enter code here... If ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False ActiveWorkbook.ExclusiveAccess End If YOUR CODE HERE Enter code here...If Not ActiveWorkbook.MultiUserEditing Then Application.DisplayAlerts = False

Re: $$Excel-Macros$$ sharing of excel workbook

its a lot of macro for different functions can it be done by your suggestion? On Wed, Aug 27, 2014 at 2:35 PM, Vaibhav Joshi wrote: > Hi > > Try converting macro to excel add-in & can install it to all user. I am > not sure but it might work. > > Cheers!! > > > On Wed, Aug 27, 2014 at 6:57 PM,

Re: $$Excel-Macros$$ sharing of excel workbook

Hi Try converting macro to excel add-in & can install it to all user. I am not sure but it might work. Cheers!! On Wed, Aug 27, 2014 at 6:57 PM, Hilary Lomotey wrote: > Hello Experts, > > i have an excel templates where i want users to be able to access it > almost at the smae time if the so