Excel 2007 Protected worksheet with a Calendar object linked to a cell
Posted on 2011-03-09
Thanking you in advance for your help and thanking everyone again for all their help in the past!!!!!!!
I have an Excel 2007 worksheet that is protected that I have inserted a Calendar object (v12.0) and that calendar is linked via the properties to a cel (A10). That cell is UNlocked so that when the calendar updates by the clerk the cell changes.
The date that the calendar is defaulting to is the date that I created and protected the sheet. After a month or so this is a pain to have to pick the right month and eventually year so that the date is right.
Is there a way in either the Calendar properties or via VB to have that Calendar object default to Now() or Today(). I tried typing (Now) and Today() in the Calendar's properties but it just reverts back to the originally created date.