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

Heera

Guest

Posts: n/a

13th Jul 2010

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

« Mark if checkin date is within 30 days of checkout date where name isthe same. | Speed of Macro on 2 PC »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2007 "Protect Sheet" option not available	Fabz	Microsoft Excel Programming	1	14th May 2010 12:31 PM
Excel 2007 error msg when saving - "Errors were detected while saving FILENAME. Excel may be able to save the file by removing or repairing some features"	Tim	Microsoft Excel Discussion	1	15th Jul 2008 12:18 AM
Disabling 'Cancel' option when saving work (Yes/No/Cancel)	jsmarsha@wisc.edu	Microsoft Excel Programming	0	11th Jul 2006 09:28 PM
Handeling buttons on save,cancel,no dialogue box of Excel Sheet	asim_i2001@yahoo.com	Microsoft Dot NET Framework	0	23rd Aug 2005 01:56 PM
Damaged Hyperlink in Excel 2003 after saving an Excel Sheet	Andy	Microsoft Excel Discussion	3	20th Dec 2004 01:17 PM