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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to use the "Alt+N" in a macro (https://www.excelbanter.com/excel-discussion-misc-queries/234921-how-use-alt-n-macro.html)

Dale

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

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

Gord Dibben

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

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

On Wed, 24 Jun 2009 14:05:01 -0700, Dale
wrote:

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

All times are GMT +1. The time now is 12:33 AM.