| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Workbooks
I am trying to write a macro to display a warning about losing change history whenever a user turns off sharing. This file has several pivot tables so the users are forced to turn sharing off to refresh the tables. I have been trying to find a way to monitor "Tools", "Track History" click events to load the warning box. I can't use the built in dialog boxes, because that particular dialog is not available in the normal X1etc. Any help would be greatly appreciated. By the way, I'm on a mac with Office X. -- dodman ------------------------------------------------------------------------ dodman's Profile: http://www.excelforum.com/member.php...o&userid=24133 View this thread: http://www.excelforum.com/showthread...hreadid=377585 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbooks-shared headers and footers | New Users to Excel | |||
| shared workbooks | Excel Discussion (Misc queries) | |||
| suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
| Shared Workbooks | Excel Worksheet Functions | |||
| Using VBA with Shared Workbooks | Excel Programming | |||
![dodman[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
