View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
faustino Dina faustino Dina is offline
external usenet poster
 
Posts: 10
Default Causing all calculated cells to refresh...

Hi,

I'm new to Excel programming. I need to cause all the Workbook to refresh
the calculated cells when de document is opened. I tryed the following.

Private Sub Workbook_Open()

MsgBox "STARTING"
Me.RefreshAll

End Sub

The message box appears as expected, but the Me.RefreshAll doesn't works.
What should I do?
In which order the cells are refreshed?

Thanks in advance
Faustino