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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started