Question: Record & create the next macro buttons (with suitable text on the buttons): 2. A macro named printAtoN that prints the current employee
Record & create the next macro buttons (with suitable text on the buttons):
2. A macro named "printAtoN" that prints the current employee report (columns A to M).
3. A macro named "printPDF" that prints to a PDF file the current employee report (columns A to M).
4. A macro named "printChoice" that prints the current employee report (columns A to M) according to user choice - using one button (see example below).
5. A macro named "protectWeekends" that deletes the content of the current employee data (Personal details and the start\ stop hours),
then protects (without password) every row, where the date falls on Friday or Saturday and then protects the sheet.
6. A macro named "saveData" that saves the currnet file.
7. A macro named "quitXL" that quits Excel.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
