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.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.