Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I attemped to use the following code to force users to save the workbook
with a certain name. It is not working, and produces ambiguous results. Any ideas. Thanks in advance. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim filename As String filename = Application.GetSaveAsFilename If Not UCase(filename) Like "*AIR CONTAINER*" Then MsgBox "Save with correct name" Cancel = True Else Cancel = False End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
validate | Excel Discussion (Misc queries) | |||
validate | Excel Discussion (Misc queries) | |||
Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
Looking up a name and then being able to validate it | Excel Worksheet Functions | |||
How to validate | Excel Worksheet Functions |