LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 102
Default Turning off Selection/sizing handles?

You can do most of this but not move them much at all:
Add the boxes, format them so to add text, under the
Protection tab uncheck Locked, with Properties tab pick
'Move and size with cells'. Protect the sheet, and check
format columns and rows - that gives some resizing of the
object when the row or column size is changed that the shape
covers.

Without going into this in detail - have a look at using an
Organizational Chart - 4th one down from the submenu Insert
Picture .


Regards
Robert McCurdy

"Tom-n-Nash" wrote in
message
...
A page of my teacher's gradebook project is a "seating
chart". I want to have
rectangular boxes appear on a "blank" sheet for each
student in the class
list. The objects should be movable with the mouse, and
snap to a grid that
represents rows of desks. Eash Box will have a student's
name on it.

I need to A) Turn off sizing handles and B) use objects
that are pre-defined
(size), but will allow text to be written to them (student
names). C) be free
floating on the sheet so they can be moved.

Any ideas?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Sizing Handles Brian Gardner Charts and Charting in Excel 3 June 28th 08 08:16 PM
How do I enlarge the spreadsheet that has no sizing handles? Kathy975 Setting up and Configuration of Excel 2 July 13th 06 11:28 PM
Button sizing handles do not appear alex Excel Worksheet Functions 3 May 27th 05 03:51 PM
Sizing handles on my chart titles don't work! Nicole Charts and Charting in Excel 2 March 4th 05 06:14 AM
The 'sizing handles' on the axis titles don't work!! Nicole Charts and Charting in Excel 1 March 4th 05 12:11 AM


All times are GMT +1. The time now is 02:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"