Hi all,
anybody use calendar control to give name to a sheet.
I use simple VBA like activesheet.name = calendar.value (calendar click renames worksheet), but after I manually rename sheet (right click on sheet tab then rename), next time I click the calendar excell gives me error report: error with method .value on calendar object.
Anybody had a similar problem?