Thread: [Solved] Excel to auto populate dates based on start and end
View Single Post
 
Old 04-21-2014, 03:14 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Two problems:
1. You didn't add the macro to your 'Inputs' worksheet's code module. Instead, you created a new module and added it to that.
2. You renamed the macro, from 'Private Sub Worksheet_SelectionChange(ByVal Target As Range)' to 'Sub AutoDate()'.
Both actions prevent the macro running automatically.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote