Виконано

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.)

Виконано:
Необхідні навички

Перегляд відповідних навичок

Схожі проекти

Інші речі, які люди роблять на Freelancer

Схожі статті

Новітні статті

Хочете заробити?

  • Визначте бюджет та часові рамки
  • Виділіть Вашу пропозицію
  • Отримайте оплату за Вашу роботу

Найняти фрілансерів, які також подавали заявки в цей проект

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