Prevent turning on workbook Sharing

[TheAntisocial]

Hi there.

I am running into problems with users Sharing workbooks that rely on a lot of VBA.
It doesn't matter how many times I tell them not to they still keep doing it and then complaining when the buttons don't work.

Does anyone know if there any way to either:

1) When they click the share button they get a message instead of the shared workbook UI

or

2) Grey out the share button when the workbook opens so they can't even press it.

Any help is very much appreciated.

Thanks

 

[RoryA]

What format is the workbook? A 2007+ XML format, or an .xls file?

 

[TheAntisocial]

Ah yes, sorry that would help, it's 2010 xlsm

 

[RoryA]

Are you familiar with modifying the Ribbon using the CustomUI editor?

 

[TheAntisocial]

I am yes

 

[RoryA]

Cool - you basically need this:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
	<commands>
		<command idMso="ReviewShareWorkbook" enabled="false"/>
		<command idMso="ReviewProtectAndShareWorkbook" enabled="false"/>
		<command idMso="ReviewTrackChangesMenu" enabled="false"/>
	</commands>
</customUI>

in the CustomUI14 part.

 

[TheAntisocial]

Hi Rory, thanks for the help, that would work a treat if I was still at my last employer, this one however will not let me install Custom UI Editor, how rude!
Is there any way to do this without the Editor?

 

[RoryA]

Can you download Excel add-ins? If so, try Andy's editor here: Ribbon Editor 2010
If not, you're stuck with renaming the file as .zip and then manually adding the relevant bits which is not as straightforward!