Shared Workbooks
 

I am trying to write a macro to display a warning about losing chang
history whenever a user turns off sharing. This file has several pivo
tables so the users are forced to turn sharing off to refresh th
tables. I have been trying unsuccessfully to find a way to monito
"Tools", "Track History" click events to load the warning box. I can'
use the built in dialog boxes, because that particular dialog is no
available in the normal X1 etc. Any help would be greatly appreciated
By the way, I'm on a mac with Office X

--
dodma
-----------------------------------------------------------------------
dodman's Profile: http://www.excelforum.com/member.php...fo&userid=2413
View this thread: http://www.excelforum.com/showthread.php?threadid=37752