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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!