Running calendar script in Excel
I have been tasked with recreating a very specific format of daily calendar for multiple users in an office to log appointments all in the same file to be seen by everyone. The previous version, created by someone in another branch who has since retired, used a template of 10 daily (Monday-Friday only) blocks, with macros for zooming in and out, on one tab to create other individual monthly tabs within a yearly book. I know he used a vba script of some sort to populate these monthly tabs, as I can see the macros, but not access the actual scripts as he had them protected. To add to the complexity, these monthly tabs were set up to follow the actual spacing of the calendar month- i.e. April starts on a Thursday, so not only would the script assign the correct Template 4 for thursday as the 1st of the month, it would physically leave 3 blank areas for the monday-wednesday that were the 29-31st of March. Attempting to search for any of these issues, much less all on combination, has been fruitless, and I clearly don't have the knowledge to write something so complex from scratch.
|