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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Is it possible to disable a single sheet for ActiveWorkbook.Refres (https://www.excelbanter.com/excel-programming/434103-possible-disable-single-sheet-activeworkbook-refres.html)

AFSSkier

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

Dave Peterson

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

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

All times are GMT +1. The time now is 10:01 AM.