Initializing variable vs. comand button

[M.]

Hi,

when i opening workbook, i'd like to initialize some variables and set
enable state of comand button to false?

Regards,

Milos

 

[Bill Li]

Hi Milos,

Create a macro with name Autpen and initialize the
varialbes in the macro.

Regards

Bill

 

[M.]

thank's bill, but my controls resides on worksheets.

Regards

Milos

 

[M.]

Sorry Bill, that's work

Regards

Milos

thank's bill, but my controls resides on worksheets.

Regards

Milos