Alan
What version of Excel are you using?
Do you have anything in the BeforeSave event?
Do your comboboxes have anything in the LinkedCell properties?
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com
"Alan Lyall" wrote in message
. au...
Hi
We have a workbook that has a number of worksheets with comboboxes that
have
a list of values. When a selection is made, code is executed to change the
appearance of the associated worksheet using the object_change event.
Unfortunately when SaveAs is used, this event appears to be triggered and
all the code is executed for all the worksheets with a combobox with a
change event defined. This leaves the user faced with a different
worksheet
to the one they were observing prior to issuing the SaveAs command.
Is there an easy way to stop this happening? Or is there an easy way to
return them to the worksheet they were observing prior to issuing the
SaveAs
command?
My testing has indicated that the _click event is also triggered by
SaveAs,
the AfterUpdate event is not triggered for SaveAs, but also not triggered
by
mouse selection from the list and the BeforeSave event is actioned prior
to
the _change event when using SaveAs.
Thanks
Alan