I use Excel 2000 at work and as you are aware there is a bug with "view
all windows in taskbar" option for shared workbooks. It gets turned off
when you open a shared workbook. I have fixed the bug with the help of
this newsgroup, by inserting a class module, which resets it to "on"

My question is, the same problem occurs with calculation option, it
gets set to manual. Can I reset it to automatic with a class module, or
by some other means, and if so, how? TIA

Greg