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: garilou@cgocable.ca
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: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

.

__,_._,___

Tidak ada komentar:

Poskan Komentar