How to change cell color from VBA assigned color

My VBA code is housed in my personal workbook, and one of the things it does is changing cell colors. After I run the VBA, which has a defninite end and does not continuously loop or anything, I can no longer change the cell colors. Is there a way to assign a color using VBA, but still be able to change that cell color after closing the VBA interface? There are no VBA modules in the file that I want to manually change the cell color in.

Can you post your code from the Personal workbook?

I can no longer change the cell colors.

What exactly does that mean; how did the code color the cells? What method are you using to manually change the color? What exactly happens when you try; error, nothing, message?

Originally Posted by AlphaFrog

Can you post your code from the Personal workbook?


What exactly does that mean; how did the code color the cells? What method are you using to manually change the color? What exactly happens when you try; error, nothing, message?

I defined some colors for certain cells in the VBA code, and when try to edit the cell and choose a specific color, nothing happens. I can change it to the default yellow by clicking the ribbon button, but it will not let me choose a color when looking for a specific color or no color.

**EDIT**

Well that's odd. I have to get this report done so I went back to doing it manually, and I'm having the same issues despite not running any VBA code at all. That's not good - time for a restart and hope for the best! Thanks for your time folks...