Hi, The code below will save a xlsm file as a xlsx file using the same name. I need it to prompt me with the name highlighted in blue so I can change it slightly if needed before saving.
Can anyone help, thanks in advance.
Sub NewFile() ' ' NewFile Macro ' ' Keyboard Shortcut: Ctrl+n ' Dim sName As String With ThisWorkbook If Not .Saved Then Exit Sub sName = .FullName sName = Left(sName, InStrRev(sName, ".")) & "xlsx" Application.DisplayAlerts = False .SaveAs FileName:=sName, FileFormat:=xlOpenXMLWorkbook End With End Sub
Bookmarks