Sabtu, 03 Januari 2015

[ExcelVBA] Re: Stopping calculation and iterations before save.


Sorry about the previous code: 

I copied it from a previous text that I had written outside of Excel.

Private Sub Workbook_BeforeSave() 
provokes an compiling error.

The code that does not work is written in my Workbook as:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ 
Cancel as Boolean)
With Application 
.Iteration = False 
.Calculation = xlManual 
.CalculateBeforeSave = False 
End With 

End Sub

By the way, I do not quite understand why the parameters are required.



Posted by:
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (2)
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: to enter the ezine, then search the ARCHIVES for EXCEL VBA.

Visit our ExcelVBA group home page for more info and support files:

More free tutorials and resources available at:




Tidak ada komentar:

Posting Komentar