Hi
put the following code in your workbook module:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Cancel = True
End Sub

--
Regards
Frank Kabel
Frankfurt, Germany

"majikman " schrieb im
Newsbeitrag ...
i've created a macro such that when a user saves, it will copy the
contents in the workbook that needs to be saved into an excel file
located on a server. this works fine and all but what i would like to
be able to do is to stop excel from saving the current workbook
because
this workbook is huge and i don't want the user to wait for the
workbook everytime he hits the save button.

one more question, is there an event for the autosave? i'd like to
have
auto save also save to the excel file on the server.

last question. how could i save the contents of a text box to another
file without having to save the entire textbox?

thanks in advance for your help


---
Message posted from http://www.ExcelForum.com/