| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
run a macro when clicking on "save as"
Hello,
How to run a macro when I click on Save As? When I click on "save as" I want a macro to run, do something, then the "save as" will take place and the save as window appears. thanx in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run a macro when clicking on "save as"
In "Thisworkbook", take a look at the BeforeSave event:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) End Sub -- Regards Andy Wiggins www.BygSoftware.com Home of "The Excel Auditor" and "Byg Tools for VBA" "M K W" wrote in message ... Hello, How to run a macro when I click on Save As? When I click on "save as" I want a macro to run, do something, then the "save as" will take place and the save as window appears. thanx in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
run a macro when clicking on "save as"
Before_save can be used. In case the file is saveasUi
variable will be true if you are saving it the first time or you are doing a Save As event. Regards Sharad. -----Original Message----- Hello, How to run a macro when I click on Save As? When I click on "save as" I want a macro to run, do something, then the "save as" will take place and the save as window appears. thanx in advance . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
| Macro to Insert Current Date into cell - Macro to "Save As" | Excel Worksheet Functions | |||
| "CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
| "Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
| HELP! Clicking "$" button changes format to ";;" not what it shoul | Excel Discussion (Misc queries) | |||
Linear Mode
