Code to declare Workbook Sheet format?

Status
Not open for further replies.

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
 
Status
Not open for further replies.
Back
Top