Ufdjrw

Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?

Which was the first story featuring espers?

C++ check if statement can be evaluated constexpr

Non-trope happy ending?

Permission on Database

What is the difference between lands and mana?

How to explain what's wrong with this application of the chain rule?

What is the English pronunciation of "pain au chocolat"?

Pre-mixing cryogenic fuels and using only one fuel tank

What features enable the Su-25 Frogfoot to operate with such a wide variety of fuels?

Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?

Why do Radio Buttons not fill the entire outer circle?

Is there any evidence that Cleopatra and Caesarion considered fleeing to India to escape the Romans?

When were female captains banned from Starfleet?

How do you make your own symbol when Detexify fails?

What (the heck) is a Super Worm Equinox Moon?

Change the color of a single dot in `ddot` symbol

What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?

Biological Blimps: Propulsion

What to do when eye contact makes your coworker uncomfortable?

It grows, but water kills it

Why is it that I can sometimes guess the next note?

Can I cause damage to electrical appliances by unplugging them when they are turned on?

Stack Interview Code methods made from class Node and Smart Pointers

How do you prevent resizing of a shape/textbox but allow moving?

Prohibit 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

0

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

share|improve this question

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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 | 

0

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

share|improve this question

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  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

share|improve this question

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

share|improve this question

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

share|improve this question

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

edited Mar 7 at 8:08

Pᴇʜ

24.3k63052

asked Mar 7 at 4:59

xg49xg49

1

asked Mar 7 at 4:59

xg49xg49

1