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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…