Is it possible to disable a single sheet for ActiveWorkbook.Refres

  • Thread starter Thread starter AFSSkier
  • Start date Start date
A

AFSSkier

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.
 
Check your earlier post.
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.
Click to expand...
 
Back
Top