The best way to do that might be to create a public sub in the workbook and call that to set the property.

dim b_setting as boolean

Public Sub MyValue(bValue as boolean)
b_setting = bValue
end sub

or add property Get/Let routines to the workbook code module.



--
Tim Williams
Palo Alto, CA


"Mark VII" wrote in message ...
Thanks for that suggestion. It helped a lot, but it would be nice to be able
to manipulate a property in one workbook from another workbook's code.

Any suggestions?

"Tim Williams" wrote:

.... or only setting calculation back to automatic if it was initally set that way?