Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.access.macros,microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Setting 'Track Changes' as default
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 | |||
setting default filter setting | Charts and Charting in Excel | |||
help with setting up a spread sheet to track survey results | Setting up and Configuration of Excel | |||
Need help setting up a way to track Prescriptions | New Users to Excel | |||
Track Changes in Excel as Default | Excel Discussion (Misc queries) | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |