| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving a Workbook: Forcing User to Rename before Saving
Code ------------------- Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI = False Then MsgBox "Please choose Save As to save this workbook.", vbInformation Cancel = True End If End Su ------------------- You may be able to automate the SaveAs function as well. -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop user from saving workbook unless cell is filled in | Excel Discussion (Misc queries) | |||
| How to rename workbook that I am editing without saving? | Excel Discussion (Misc queries) | |||
| saving the last user who edited the file | Excel Discussion (Misc queries) | |||
| Prevent user from saving workbook | Excel Discussion (Misc queries) | |||
| Saving : Changed by another user | Excel Discussion (Misc queries) | |||
![kkknie[_47_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
