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

  • Thread starter Thread starter Dale
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alt down arrow shortcut not working 0
Alt codes 4
Excel macro list - Alt+F8 2
How to make PC respond to dialouge box with text and clicking button itself? 0
Macro error 1
Macro problems 3
Excel Macro problems 1
Windows 10 How can I fix my corrupt registries? 1

Back
Top