lior03
02-06-2006, 10:40 AM
hello
you mark my previous question as solved,it's not.
i am trying to get on the statusbar a progressor like a clock,as to how long it take a macro to completein this case saving a workbook.please help.
Dim Pct As Double
For Pct = 0.1 To 1
Application.StatusBar = "now processing " & Format(Pct, "00.00%")
ActiveWorkbook.Save
Next
thanks
you mark my previous question as solved,it's not.
i am trying to get on the statusbar a progressor like a clock,as to how long it take a macro to completein this case saving a workbook.please help.
Dim Pct As Double
For Pct = 0.1 To 1
Application.StatusBar = "now processing " & Format(Pct, "00.00%")
ActiveWorkbook.Save
Next
thanks