How to use the "Alt+N" in a macro

D

Dale

I have a simple macro that I want to use the "Alt+N", "Alt+S" commands. How
do I write this in the macro?
 
G

Gord Dibben

Alt + N and Alt + S do nothing in Excel AFAIK

Maybe you mean CTRL + N for new workbook and CTRL + S for Save As?

Workbooks.Add

Application.Dialogs(xlDialogSaveAs).Show


Gord Dibben MS Excel MVP
 
Top