Stop Saving

M

majikman

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

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

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

thanks in advance for your hel
 
J

Jake Marx

Hi majikman >,

Excel provides a BeforeSave event that you can use to cancel the save if
you'd like:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
If Not SaveAsUI Then Cancel = True
End Sub


This example will only cancel the save if the Save As dialog is not going to
be shown (ie, the user hits save or selects File | Save). If you want to
block all saves of the workbook, then you'd just use Cancel = True.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
F

Frank Kabel

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