slotguy87
New member
- Joined
- Oct 14, 2016
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Location
- Las Vegas, Nevada
- Excel Version(s)
- 2016
Could anyone please help me with the VBA code to make sure that all sheets/cell formatting doesn't change from General?
I have a Project Template that I use everyday. Lately every time I open it, every cell on every sheet, has been formatted to TIME. The only way I've been able to prevent this is to protect the sheets. But, I work in a fast paced, deadline demanding industry and don't always remember to protect before saving/closing. There is no code behind any of the sheets, just a bunch of vlookup formulas which have and are still working just fine. Everything is working just fine, except this TIME formatting when I open the workbook.
Thanks in advance
Andy
slotguy87
I have a Project Template that I use everyday. Lately every time I open it, every cell on every sheet, has been formatted to TIME. The only way I've been able to prevent this is to protect the sheets. But, I work in a fast paced, deadline demanding industry and don't always remember to protect before saving/closing. There is no code behind any of the sheets, just a bunch of vlookup formulas which have and are still working just fine. Everything is working just fine, except this TIME formatting when I open the workbook.
Thanks in advance
Andy
slotguy87