I like it....That solves the major flaw in this application and will make it much more usefull. Thanks. Is it unlikely that there is a solution to clear the content of cell C15 on entering any sheet in this workbook. I found a way to do this for individual sheets but it would require changes on each sheet and each new sheet in the future.