Can I restart the setup after I have completed it
After you have completed the setup, you can make changes later if necessary by running the RestartSetup macro. To do this, follow these steps:
- Save the existing file
- Save a new copy of the file to a new filename
- Go into the view ribbon in Excel, and Macros->View Macros
- Select RestartSetup and click Run
- You will then be able to make any settings changes and provide a new year start date
When you run this macro, all of the leave you have already entered will be removed, so make sure you save the file before running this if you don’t want to lose your leave. Your existing employees will not be removed.
If you are following these steps to reset the tool for a new year, it can take a bit of time to run, and give the appearance that it is not responding. Just be patient, it will finish 🙂
