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

H

Heera

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
 

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

Top