Solved

3806 Berwick Example.xlsm,  "Map" worksheet - shape manipulation revision will not work.

Posted on 2016-09-28
2
38 Views
Last Modified: 2016-09-29
In 28960761 Not Locked.xlsm, in the "Map" worksheet, a change to a value in Rows 1 and 3 for columns F to AI, will change the size of the shape in the map.

I attempted to use file 28960761 Not Locked.xlsm as a template to create a new file called 3806 Berwick Example.xlsm

But In the "Map" worksheet in 3806 Berwick example.xlsm, I moved the adjustable values from Rows 2 and 4 to column B.
Now, a change to the values in column B will not change the size of the shape in the map.
I am seeking help to fix this problem.
3806-Berwick-Example.xlsm
28960761-not-locked.xlsm
0
Comment
Question by:gregfthompson
2 Comments
 
LVL 81

Accepted Solution

by:
byundt earned 500 total points
ID: 41821573
Problems I noticed:
1. Berwick sub UpdateMap_Click is not called automatically. In Not Locked, it was called by a Worksheet_Change sub in the Map worksheet.
2. Berwick sub UpdateMap_Click gets the name of the shape objects from worksheet Adjustable Weighting Table column A--but the shape names actually occur in column C. Furthermore, those values start in row 5, not row 7 (Constant FIRST_DATE_ROW). As a result, even if UpdateMap_Click is called, it can't reference any of the shape objects.
0
 

Author Closing Comment

by:gregfthompson
ID: 41821643
Thanks heaps. Much appreciated.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question