Items selected where Question includes shift or Answer includes shift
Questions & Answers
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.
Q: My company uses your scheduling software. We are having a slight issue. The software works perfectly on the profile of a previous employee but when we tried to move it to my profile, it doesn't work properly. The issue is building a new roster. I can do everything else but build a new roster. Could you help us with this issue?
A: I am not quite sure what you mean by new profile? However the most likely reason is your Excel version/set up and how it runs (or does not run) macros. Without macros enabled the software will not function. Information on enabling macros can be found at https://bizpep.com/shiftscheduler.html . For additional detail please refer to your Excel help.
Q: I am experiencing problems with my new shift scheduler, the buttons that run the macros have gone very small and now it't not very usable. Do you know how I can fix the buttons?
A: Possibly you have change the zoom? You can set it to 100% from the tool bar for normal size. You could also try re installing a clean version of the software to eliminate any formatting changes that may have been made. If you still have difficulty send me a screen shot and I can assist further.
Q: How is the roster period defined?
A: You define the roster period by clicking Add Shifts to add the required number of shifts for the period you want (the initial default is 5). The settings i each shift determine its length. The length of the period is the duration from the first shift to the last. See the Help file https://bizpep.com/shiftscheduler.html for details.
Q: How can I see the complete roster next to each other...currently there is only 4 periods....
A: When you Add shifts they are displayed in the next colums. The full roster shifts are displayed. The initial number of shifts is 5. Click Add Shift to add additional shifts. Format Print formats a printable version of the roster. See the Help file https://bizpep.com/shiftscheduler.html for details.