| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trap Save / Save As for all Excel workbooks
I'm trying to accomplish the following in Excel 2003: Intercept the
Save / Save As command and prompt user to enter a string that will be used to populate one of the document properties. This was easy enough for any new documents (via Workbook_BeforeSave placed in BOOK. XLT). However, how can I achieve this for files the user, say, receives via email from someone else? I came across a post suggesting Win32 API for a similar task.. Any ideas would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trap on close event and control save | Excel Programming | |||
| Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
| I need an excel plug in to save workbooks in adobe acrobat format | Excel Discussion (Misc queries) | |||
| Excel VBA-How to save sheet w/in all workbooks as sheet1? | Excel Programming | |||
| Using VBA in Excel to Make a Folder to Save Workbooks in | Excel Programming | |||
![Aurora[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
