Disable the cancel option while saving the excel sheet-Excel 2007
 

Hi All,

I run a macro and it saves a file on my shared drive, while saving I
can see a small window which says "Saving as: \\filepath
\filename.xls"
There is a "Cancel" button and if I click on cancel the data doesnt
get saved and an error message pop's-up which says "Document not
saved."

I used the option "Application.Dispalyalert = False" but still it is
showing the small window. I am using excel 2007. I dont want that
small window to apper while saving.

Regards
Heera Chavan