View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AFSSkier AFSSkier is offline
external usenet poster
 
Posts: 94
Default Is it possible to disable a single sheet for ActiveWorkbook.Refres

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