Check your earlier post.

AFSSkier wrote:

Is it possible to disable sheet1 from being Refreshed by an
ActiveWorkbook.RefreshAll?

I have Active ComboBoxes on sheet1 that I don't want it to distrubed by a
RefreshAll.

If it is not possible to disable a single sheet, is it possible to do the
following?

Copy the values in cbo1, cbo2, cbo3 and cbo4.
Then replace the values back in the respective ComboBox after RefreshAll.

--
Thanks, Kevin

--

Dave Peterson