::Global Macros::

[jekstein]

Can any one remind me how to create a global workbook macro that is not attached to a button or cell, it should just run when the workbook is open?

For example I want to create a code that checks all the cells for a value and if there is no value then it should load a Zero value in the cells.

 

[jekstein]

:bump:

:bump:

 

[hayden]

From the help section of VBA

Occurs when the workbook is opened.

Private Sub Workbook_Open()
Example
This example maximizes Microsoft Excel whenever the workbook is opened.

Private Sub Workbook_Open()
Application.WindowState = xlMaximized
End Sub


Just put that sub name in a module I think.

Good Luck

Hayden