Hi

When using events you must match the event signature set out in VBA so
the BeforeSave event must be:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _
Cancel As Boolean)
'code
End Sub

The problem with this is that it runs BEFORE the save at which point the
properties will not yet have been updated. You may be able to play
around with it to have it save, update the cells on your sheets and then
save again. You can find more info on events from Chip Pearson at:

http://www.cpearson.com/excel/events.htm

Regards
Rowan

More on events at:

the majestic ferny wrote:
Hi Rowan. Is there a way to have it work on both Open() and
BeforeSave() events? If I try to just add another sub with
BeforeSave() I get a compile error. I guess I would like the cell
values to update if a user saves the document but then keeps working on
it.
Thanks for your great assistance!