View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default auto update of date and time whenever changes are made to a xc

Hi,
If Alt with F11 isn't working, right-click your sheet tab and choose View
Code.
The VBA window will open.
Paste Mike's code into the blank section on the right, then close the VBA
window.
Dave.