command buttons

[camron107]

hey,

I have a workbook with command buttons on every sheet. The buttons function fine.... however as soon as I share the workbook over a network, they stop working.

Im aware that macros cannot be viewed or edited in a shared workbook... however, the workbook will function fine on TWO computers in my office, but none of the others...

I have no protection applied, change history is ON, and it is shared in a folder on the network.

Any ideas of this paranorma?

 

[Dave Peterson]

Maybe the others have their security set too high (and have macros disabled)???

Tools|macro|security|Security tab
(for xl2002)

 

[camron107]

thanx again mr peterson... always come up with the goods.