Items selected where Topic is Shift Scheduler
Questions & Answers
Topic: Shift Scheduler
Q: Hi there, I just got a new computer and IT moved my files over, and not my shift scheduler is not working. Are you able to let me know how to set it correctly so I am able to click the buttons on it again?
A: I just checked and your file runs on my system, most likely your macros are not enabled ... how you enable macros depends on your system. The following info may help? Enable Macros using Excel 2010/2007 to open a .xlsm file - When you open the .xlsm Excel file with Excel 2010/2007 macro status and options will depend on your system and security settings. The .xlsm extension indicates the file is an Excel Macro-enabled Workbook. If macros are not enabled from the top ribbon click Developer, Macro Security to access the Trust Center. If the Developer tab is not displayed, click the Microsoft Office Button, Excel Options, Trust Center, and the Trust Center Settings Button. From the Trust Center click Trusted Locations, Add new location, browse to the directory in which the Excel software file is saved, select the sub folders option if required, click OK, and then click OK once more to exit the Trust Center. This enables macros for any files saved in a Trusted Location. Only files that you trust should be saved in Trusted Locations, if you save all your Bizpep Excel files to a trusted directory macros will be enabled and they will run correctly. For additional information see Microsoft's Create, remove, or change a trusted location for your files. Alternatively from the Macro Settings category in the Trust Center you can select 'Enable all macros' however this enables macros in files from any location and should only be used when all files you access are trusted. Enable Macros using Excel 93-2003 to open a .xls file - If when you open the Excel software you are not presented with an option to enable macros you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.