I have a workbook, each sheet is protected. Each sheet is a report, which includes inserted images. I would like to be able to use arrows and textbox's to annotate the images in a report. I need help with two parts.
1. I need two individual macros. One to generate an Arrow, and the second to Generate a TextBox. Both formatted black, heave, and 3D as in the example. The macros will be launched from the ribbon, so the objects should be launched in the center of whatever the screen is presently displayed.
2. New reports are generated by a macro that creates a copy of the current report, and deletes data that does not need to be carried over (this include images contained within, and any textbox's / arrows over the images). When new reports are created, I need the TextBox & Arrows to be removed from the new report. So the code would need to be specific for only these two items.
Any help on this would be greatly appreciated!!!! Thanks in advance!
1. I need two individual macros. One to generate an Arrow, and the second to Generate a TextBox. Both formatted black, heave, and 3D as in the example. The macros will be launched from the ribbon, so the objects should be launched in the center of whatever the screen is presently displayed.
2. New reports are generated by a macro that creates a copy of the current report, and deletes data that does not need to be carried over (this include images contained within, and any textbox's / arrows over the images). When new reports are created, I need the TextBox & Arrows to be removed from the new report. So the code would need to be specific for only these two items.
Any help on this would be greatly appreciated!!!! Thanks in advance!