Thread: If cell is blank automatically enter today's date in the same cell
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben[_2_] Gord Dibben[_2_] is offline
external usenet poster
  
Posts: 621
Default If cell is blank automatically enter today's date in the same cell
You should re-think this statement GS

If the workbook is saved with that sheet the active sheet then the code will run when the
file opens

Code will run only when the sheet is activated.

Opening a workbook does not activate a sheet.



Gord



Reply With QuoteReply With Quote