Solved How to lock buttons & textboxes on a work sheet?

Microsoft Excel 2010 - complete product...
November 17, 2016 at 16:17:31
Specs: Windows 7
LOCKING CONTROL BUTTONS IN PLACE..USING ACTIVEX OPTION BUTTONS, TEXTBOXES, LABELS AND COMMAND BUTTONS ON AN EXCEL WS...WOULD LIKE THEM TO STAY WHERE I PLACE THEM. THIS WS WILL NOT BE SCROLLED...

See More: How to lock buttons & textboxes on a work sheet?

Report •

#1
November 17, 2016 at 17:52:14
✔ Best Answer
Please shut off your Caps Key, type in all caps is considered SHOUTING.

Try:

Right click the button, choose "Format Control", then "Properties", check "Don't move or size with Cells".

For Text Boxes:

Text boxes created from the "Insert ribbon > Text box"
will not move with the chart.
Can NOT copy and paste.

Text boxes created from the "Chart Tools Layout > Text box"
will move with the chart.
Can copy and paste

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
November 17, 2016 at 19:32:01
Appreciate your response. Worked fine for my application. Sorry about the caps, didn't realize they were active...will try not to let that happen again...

Report •
Related Solutions


Ask Question