Excel VBA - 13/10/2016 10:36 EDT

Task #1: Click on the green “UPLOAD“ arrow in the worksheet TEMPLATE (row 814) to insert and resize the specified images in the designated cells in worksheet REPORT. Origin Files: All image files must be named as specified in worksheet Template/ column Q/rows 807 - 906. All image files shall be located in the Folder C:/MirfinMP. File endings “.jpg“ or “.jpeg“ shall be accepted. There can be up to 45 image files. File size may not exceed 300KB per image. Not all specified images may be available, in which case only the available images are inserted in the respective cells. Destination Cells: Each image must be sized to fit the size of the destination cell exactly. Images to have a slight shadow (if possible). There can be up 47 destination cells (image [login to view URL] is assigned to 3 destination cells). Each image shall be assigned and resized to the following cells in the worksheet REPORT: [login to view URL] -> AI25 [login to view URL] -> AI39 [login to view URL] -> AJ728; AJ945; C1103 [login to view URL] -> X1103 [login to view URL] -> C1131 [login to view URL] -> X1131 [login to view URL] -> C1159 [login to view URL] -> X1159 [login to view URL] -> C1189 [login to view URL] -> X1189 [login to view URL] -> C1217 [login to view URL] -> X1217 [login to view URL] -> C1245 [login to view URL] -> X1245 [login to view URL] -> C1275 [login to view URL] -> X1275 [login to view URL] -> C1303 [login to view URL] -> X1303 [login to view URL] -> C1331 [login to view URL] -> X1331 [login to view URL] -> B385 [login to view URL] -> Q385 [login to view URL] -> AF385 [login to view URL] -> B399 [login to view URL] -> Q399 [login to view URL] -> AF399 [login to view URL] -> B413 [login to view URL] -> Q413 [login to view URL] -> AF413 [login to view URL] -> AJ746 [login to view URL] -> AJ764 [login to view URL] -> AJ782 [login to view URL] -> AJ812 [login to view URL] -> AJ830 [login to view URL] -> AJ963 [login to view URL] -> AJ981 [login to view URL] -> AJ999 [login to view URL] -> AJ1029 [login to view URL] -> AJ1047 [login to view URL] -> C1361 [login to view URL] -> C1447 [login to view URL] -> C1533 [login to view URL] -> C1619 [login to view URL] -> C1705 [login to view URL] -> C1791 Task #2: The spelled out number in cell AJ784/TEMPLATE must be all in lower case and the currency must read “rand“ instead of “dollars“. Task #3: All inserted objects with assigned macros on both worksheets TEMPLATE and REPORT must be enabled/functional when clicked when the worksheets are in “protected“ mode. (Currently, when in "protected" mode, clicking the Objects raises the following alert: Microsoft Visual Basic Run-time error '1004': AutoFilter method of Range class failed [Abort] [Debug] Please advise the procedure to enable the intended functionality of objects in "protected" mode? (I have already tried to achieve this by unlocking the cells over which the objects and by unticking the “Locked“ tick-box in the “Format Shape“ window, but without success.)