Debugging Code Error

Hello Friends:

I have the following code in the attached sheet.

Please Login or Register  to view this content.

The code further helps to reset all cells to white background after these have turned red. When it is time for re-set at the end, I am getting an error on the following line:

For Each oneCell In rngMatrix.Resize(, rngMatrix.Columns.Count + 1)

Please help resolve this. The color should change to white for the cells containing numbers. Range is A2:J9, A10:I10.

This works great!

Originally Posted by pike

Hi gurpreet161,

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

I do have one more question. When all cells are red, code currently brings up a prompt box asking "All cells have been chosen. Reset the grid?" with the option of Yes and No. Can you help change this to "Please close the file and reopen" with the option to click just "OK" and not do anything to the file?

Also, is there a way to disable the save option on the excel file using any code?