Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prompting user before saving
Well it seems quite straight forward as you dont want to allow the use
another option other than ok but i suggest you use Msgbox Msgentr "YOUR TEXT",vbokcancel,"TITLE OF BOX HERE" stick it all in a auto_close and add the line ThisWorkbook.Close savechanges:=True (thi closes the workbook that is running the code) Of course you will have to specify what either ok or cancel will d when clicked i.e if msgbox=6 then blah! HTH Simo -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prompting user to enable a link | Excel Discussion (Misc queries) | |||
Saving user defined functions | New Users to Excel | |||
Saving : Changed by another user | Excel Discussion (Misc queries) | |||
Prompting user before saving | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming |