已完成

Create & Customize Excel VBA Macros

该项目成功由katilinas ,以$120 USD的价钱在3 天内完成。

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 USD
完成于
3 天
全部竞标
7
项目描述

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 [url removed, login to view] is assigned to 3 destination cells).

Each image shall be assigned and resized to the following cells in the worksheet REPORT:

[url removed, login to view] -> AI25

[url removed, login to view] -> AI39

[url removed, login to view] -> AJ728; AJ945; C1103

[url removed, login to view] -> X1103

[url removed, login to view] -> C1131

[url removed, login to view] -> X1131

[url removed, login to view] -> C1159

[url removed, login to view] -> X1159

[url removed, login to view] -> C1189

[url removed, login to view] -> X1189

[url removed, login to view] -> C1217

[url removed, login to view] -> X1217

[url removed, login to view] -> C1245

[url removed, login to view] -> X1245

[url removed, login to view] -> C1275

[url removed, login to view] -> X1275

[url removed, login to view] -> C1303

[url removed, login to view] -> X1303

[url removed, login to view] -> C1331

[url removed, login to view] -> X1331

[url removed, login to view] -> B385

[url removed, login to view] -> Q385

[url removed, login to view] -> AF385

[url removed, login to view] -> B399

[url removed, login to view] -> Q399

[url removed, login to view] -> AF399

[url removed, login to view] -> B413

[url removed, login to view] -> Q413

[url removed, login to view] -> AF413

[url removed, login to view] -> AJ746

[url removed, login to view] -> AJ764

[url removed, login to view] -> AJ782

[url removed, login to view] -> AJ812

[url removed, login to view] -> AJ830

[url removed, login to view] -> AJ963

[url removed, login to view] -> AJ981

[url removed, login to view] -> AJ999

[url removed, login to view] -> AJ1029

[url removed, login to view] -> AJ1047

[url removed, login to view] -> C1361

[url removed, login to view] -> C1447

[url removed, login to view] -> C1533

[url removed, login to view] -> C1619

[url removed, login to view] -> C1705

[url removed, login to view] -> 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.)

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online