| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Disable Unhide Sheet menu option | Excel Worksheet Functions | |||
| Disabling 'Cancel' option when saving work (Yes/No/Cancel) | Excel Programming | |||
| Disable option save when close excel | Excel Programming | |||
| Disable Open option in Excel Report from VB | Excel Programming | |||
| How can I globally disable the Hypertext link option in Excel? | Setting up and Configuration of Excel | |||
Linear Mode
