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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox.Enable giving error on ActiveWorkbook.RefreshAll 10
Close DropDown of ComboBox2 & Open ComboBox1 on Error 1
user form, saving values 3
Sorting a protected worksheet 1
Pivot Table Refresh 3
Hide actions while macro executes 1
Issues when opening excel through access 1
RefreshAll in a shared workbook 1

Back
Top