FN = Application.GetSaveAsFilename()
Read all about GetSaveAsFilename in help as its well
explained
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi all,
I created a macro to intercept the save and save as in
excel.
Then I want to force people to fill in the properties,
which works and
then I want to show the save as dialog.
The funny thing is that I see the dialog when I start it
inside the
vb
editor, however it never appears on the screen when I
run the code
from the workbook.
I used the following codes:
ThisWorkBook.Application.Dialogs(xlDialogSaveAs). Show
Excel.Application.Dialogs(xlDialogSaveAs).Show
Application.Dialogs(xlDialogSaveAs).Show
All of the three appear inside the vb editor but none of
them inside
my workbook(that is when the user click on the save/save
as button)
That code does work because it intercepts the save/save
as and shows
the userform i created.
Does anyone know why this is happening??
Thank you.
.