How do you prevent resizing of a shape/textbox but allow moving?2019 Community Moderator ElectionProhibit or at least detect Excel shape movementAdding Workshhet_activate and _deactivate to an existing sheet using VBA codeOnly I am able to save a macro-enabled workbook?How to make ActiveX textbox readonly but scrollable in Excel 2013?VBA Textbox value loop vlookup for number of times value is foundHow to move a shape without selecting it?Give macro access to protected sheetsHow do I prevent editing of specific cells but allow the viewer to only select them?VISIO VBA - Position shapes inside existing shapesDrag and Drop into a group - MS Visio VBA
Can I negotiate a patent idea for a raise, under French law?
Professor forcing me to attend a conference, I can't afford even with 50% funding
The meaning of ‘otherwise’
I can't die. Who am I?
Are small insurances worth it?
Can we track matter through time by looking at different depths in space?
In the late 1940’s to early 1950’s what technology was available that could melt ice?
When Schnorr signatures are part of Bitcoin will it be possible validate each block with only one signature validation?
Expressing logarithmic equations without logs
Which classes are needed to have access to every spell in the PHB?
Finitely many repeated replacements
Does Christianity allow for believing on someone else's behalf?
MySQL importing CSV files really slow
How do we create new idioms and use them in a novel?
For which categories of spectra is there an explicit description of the fibrant objects via lifting properties?
Doesn't allowing a user mode program to access kernel space memory and execute the IN and OUT instructions defeat the purpose of having CPU modes?
Which situations would cause a company to ground or recall a aircraft series?
How do electrons receive energy when a body is heated?
NASA's RS-25 Engines
Should I take out a loan for a friend to invest on my behalf?
What would be the most expensive material to an intergalactic society?
Doubts in understanding some concepts of potential energy
What materials can be used to make a humanoid skin warm?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
How do you prevent resizing of a shape/textbox but allow moving?
2019 Community Moderator ElectionProhibit or at least detect Excel shape movementAdding Workshhet_activate and _deactivate to an existing sheet using VBA codeOnly I am able to save a macro-enabled workbook?How to make ActiveX textbox readonly but scrollable in Excel 2013?VBA Textbox value loop vlookup for number of times value is foundHow to move a shape without selecting it?Give macro access to protected sheetsHow do I prevent editing of specific cells but allow the viewer to only select them?VISIO VBA - Position shapes inside existing shapesDrag and Drop into a group - MS Visio VBA
I have shapes that serve as markers in the sense that I will later read coordinates off of these markers. I want to prevent these shapes from being resized, but allow them to be dragged and dropped around the page. They are currently rectangles, but can be substituted with textboxes if needed.
Unfortunately locking the objects and protecting the page just prevents me from interacting with them at all.
excel vba
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have shapes that serve as markers in the sense that I will later read coordinates off of these markers. I want to prevent these shapes from being resized, but allow them to be dragged and dropped around the page. They are currently rectangles, but can be substituted with textboxes if needed.
Unfortunately locking the objects and protecting the page just prevents me from interacting with them at all.
excel vba
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07
add a comment |
I have shapes that serve as markers in the sense that I will later read coordinates off of these markers. I want to prevent these shapes from being resized, but allow them to be dragged and dropped around the page. They are currently rectangles, but can be substituted with textboxes if needed.
Unfortunately locking the objects and protecting the page just prevents me from interacting with them at all.
excel vba
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have shapes that serve as markers in the sense that I will later read coordinates off of these markers. I want to prevent these shapes from being resized, but allow them to be dragged and dropped around the page. They are currently rectangles, but can be substituted with textboxes if needed.
Unfortunately locking the objects and protecting the page just prevents me from interacting with them at all.
excel vba
excel vba
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
edited Mar 7 at 8:08
Pᴇʜ
23.7k62952
23.7k62952
asked Mar 7 at 4:59
xg49xg49
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 7 at 4:59
xg49xg49
1
asked Mar 7 at 4:59
xg49xg49
1
1
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
xg49 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07
add a comment |
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
xg49 is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55036384%2fhow-do-you-prevent-resizing-of-a-shape-textbox-but-allow-moving%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
xg49 is a new contributor. Be nice, and check out our Code of Conduct.
xg49 is a new contributor. Be nice, and check out our Code of Conduct.
xg49 is a new contributor. Be nice, and check out our Code of Conduct.
xg49 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55036384%2fhow-do-you-prevent-resizing-of-a-shape-textbox-but-allow-moving%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Are you using active controls or the controls on the userform?
– Lunalo John
Mar 7 at 8:26
@LunaloJohn I'm using activex controls directly on the spreadsheet
– xg49
Mar 7 at 15:07