Hi there,

Although I haven't come across this exact problem I have
come across a number of problems when trying to acheive an
action when triggered by a Change on a Combo/List Box.

My advice would be to make the change with the ComboBox
and then have a seperate procedure for saving the workbook.

This should work, you may find some information on a work
around on the Microsoft site, but it is unlikely, I found
some about a year ago, basically it said that VBA is a cut
down VB version 6.0 there was no fix and there wasn't
going to be.

Sorry to be the bearer of bad news.

Yours sincerely,

Brent McIntyre

Thanks but it was a fauly spreadsheet, I copied all the
sheets into another workbook and then recreated the
ComboBox and it all works OK now

-----Original Message-----
Hi there,

Although I haven't come across this exact problem I have
come across a number of problems when trying to acheive
an
action when triggered by a Change on a Combo/List Box.

My advice would be to make the change with the ComboBox
and then have a seperate procedure for saving the
workbook.

This should work, you may find some information on a work
around on the Microsoft site, but it is unlikely, I found
some about a year ago, basically it said that VBA is a
cut
down VB version 6.0 there was no fix and there wasn't
going to be.

Sorry to be the bearer of bad news.

Yours sincerely,

Brent McIntyre
.