Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Track changes
Hello All
I am using Windows 2K Professional & Office97. I have a macro in an access mdb that outputs various files in excel format. Is it possible either: to use access VBA instead of the access macro to specify that the excel 'Track Changes' option is automatically set to 'True'; or to specify elsewhere that all new excel files to have the 'Track Changes' option automatically set to 'True' In either case, the sub-options 'When' should be set to All, 'Who' set to Everyone, and 'Where' should be left blank (i.e. applies to the whole sheet)? I'm sure this can be done, but just can't see how! I would be grateful for any help. Many thanks Les |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Track Changes | Excel Discussion (Misc queries) | |||
"Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) | |||
Track Changes | Excel Discussion (Misc queries) | |||
Track Changes | Excel Worksheet Functions | |||
track changes | Excel Discussion (Misc queries) |