Have a message appears when the registration and closing of a file?

Office

Question:Assistance. New VBA and you all is an excellent resource, with my Excel VBA for Dummies book. Is it possible to write code that would make a message appear in Excel when save them and close a file? Not one "either / or"scenario;"" only when do both.Answer:Assistance. New VBA and you all is an excellent resource, with my Excel VBA for Dummies book. Is it possible to write code that would make...Read More

Posted: 17 Feb 2012

Tags: Have a message appears when the registration and closing of a file Have message appears when the registration and closing file

What is the problem with my event "before closing" management procedure?

Office

Question:After the opening of my workbook, hitting , locate the workbook in the project window by double-clicking on it and choosing to workbook in the drop-down list object...This is the code I wrote:Private Sub Workbook_BeforeSave(ByVal_SaveAsUI_As_Boolean,_Cancel_As_Boolean)Dim Msg As StringMSG = "Please let Cheryl know when this file"MSG = "" is final or changes have been made""MSG = "for the...Read More

Posted: 17 Feb 2012

Tags: What is the problem with my event before closing management procedure What the problem with event before closing management procedure