Open 'Save As' dialogue box using Macro

Z

Zainuddin Zakaria

I have chosen to hide the Menu Bar.
How do I let users save their work?

I plan to create a button and assign a MACRO to it so that users can click
and 'SAVE AS' their file by first typing in the file name. Can someone come
out with a macro command for this?

Also a macro command to EXIT button (without saving the file).

Thank you so much.


Zainuddin Z
 
A

ankur

Hi Zainuddin,

Try this...

Sub Test()
fileSaveName = Application.GetSaveAsFilename(fileFilter:="Excel Files
(*.xls), *.xls")
If fileSaveName = False Then
End
Else
ActiveSheet.SaveAs Filename:=fileSaveName
End If
End Sub

Regards
Ankur Kanchan
www.xlmacros.com
 

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

Save workbook without shapes 0
Menu Macro Not Executing - Need Help 1
Macro command to turn on File Menu 6
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How to record a macro within a macro 9
Excel buttons change macro file name when run on other computers 7
Getting Radio Buttons to work, that are inserted via AutoText 0
Macro Command to Exit 5

Top