Pictures in Cells - Protecting?

Hello,
     I teach elementary computers, and I often make my own online worksheets 
for the kids.  I am making an "ABC Order" sheet where I have pictures of 
animals in one column and pictures of animal names (as opposed to just 
typing the names in the cells) in another column.  The kids will slide the 
names into alphabetical order, then slide the picture of the animal next to 
it.
     My question is this; is there a way to "protect" or "lock" the pictures 
so that the kids can move them but not accidentally resize them?  I have 
tried every combination of lock and protect I can find, but I still can't 
get it to do exactly what I want.
     Thanks so much for any help you can give me!

Mommio 


0
mommio2 (9)
10/26/2007 4:27:07 PM
excel.newusers 15348 articles. 2 followers. Follow

1 Replies
586 Views

Similar Articles

[PageSpeed] 31

Mommia,

You could use the selection change event to return all pictures to their original size.  It would 
require using code: if you are interested in trying the technique, post back.

HTH,
Bernie
MS Excel MVP


"mommio2" <mommio2@insightbb.com> wrote in message news:eMgkO0%23FIHA.6068@TK2MSFTNGP05.phx.gbl...
> Hello,
>     I teach elementary computers, and I often make my own online worksheets for the kids.  I am 
> making an "ABC Order" sheet where I have pictures of animals in one column and pictures of animal 
> names (as opposed to just typing the names in the cells) in another column.  The kids will slide 
> the names into alphabetical order, then slide the picture of the animal next to it.
>     My question is this; is there a way to "protect" or "lock" the pictures so that the kids can 
> move them but not accidentally resize them?  I have tried every combination of lock and protect I 
> can find, but I still can't get it to do exactly what I want.
>     Thanks so much for any help you can give me!
>
> Mommio
> 


0
Bernie
10/30/2007 1:14:10 PM
Reply:

Similar Artilces:

how can you view cells from different worksheets in to one sheet,.
hi, I have multiple worksheets, more than 200 of them, and i wanted to summarize some cells in to one sheet, I know how to do it by entering the code manually (='7'!$D2), this shows cell d2 in sheet 7, but is there a function to do that like drag or something? You can use this macro myasin http://www.rondebruin.nl/summary.htm -- Regards Ron de Bruin http://www.rondebruin.nl "myasin" <myasin@discussions.microsoft.com> wrote in message news:07759D01-70FE-416A-B54B-009646C2C365@microsoft.com... > hi, > I have multiple worksheets, more than 200 of them, and i...

picture is not showing up in Excel
I have a picture that is in an Excel worksheet. I can see the handles and if I move the handles some, the picture will show up. However, it will not show up in print preview at all or page break preview. I can open the same file on another computer and it will show up fine. Any help would be appreciated. thanks. Check Tools -> Options ->General Do you have "Show All" selected for Objects? "cab58" wrote: > I have a picture that is in an Excel worksheet. I can see the handles > and if I move the handles some, the picture will show up. However, it > will...

Embedded pictures
Hello! I noticed that the when we set the picture property of a button or another control as embedded, it takes a lot of place. Is there an explication that show why the Access file encrease in size by more than the picture size (even if it is a bitmap, a format that is normaly heavy) Exemple: An mdb without picture would take 4 MB the same file with pictures would increase to 40 MB with only 400 KB of pictures. In JPEG format. Is it because Access uses a non efficient compression to include the image file? Thank you in advance for any suggestion! PS: I know that I can set the pictur...

Pictures don't print in outlook 2000 or 97
How do I get pictures to print when I print messages for Outlook 2000 or Outlook 97. I'm using XP Home. Thanks, Chris Hi Chris, Have you checked to make sure you have all of the latest Windows and Office Service Packs installed? I remember this issue from a whle back, and it was corrected in one of the service pack releases. Regards, Scott Atkins MCSE, MCSA Partner Technical Lead - Outlook Microsoft Technical Support for Platforms and Business Applications -------------------- >From: socialism001@yahoo.com >Newsgroups: microsoft.public.outlook >Subject: Pictures don't...

Find a empty cell in next column
hi. Dave helped me with this before, now i need more help. I use this code to find a column called PoF and the numbers written in the cells below it. This code work in every row/column (i dont need to name it). PoFRow = 0 PoFCol = 0 On Error Resume Next PoFRow = Worksheets(2).Range("PoF").Row PoFCol = Worksheets(2).Range("PoF").Column On Error GoTo 0 If PoFRow = 0 Then MsgBox "No range named PoF on worksheet:" ' & .Name ' Else Set numberPoF = Nothing On Error Resume Next Set num...

Inserting picture from "My Pictures"
When I add a pic from "My pictures" the entire picture does not appear on the slide and when I try to format it it is impossible to get it back to the same pic I am attempting to add. If I am trying to add a pic I might only get a nose or a blade of grass instead of the original picture from "My Pictures". Reduce the zoom to 10%. Coul be a too large image "PP Neophyte" <PP Neophyte@discussions.microsoft.com> a �crit dans le message de news: CA5F97E6-D4D8-401B-B066-E261024F082F@microsoft.com... > When I add a pic from "My pictures" t...

Need event macro to tab past a (calculated) cell
I have an Excel 2003 List (aka Table in Excel 2007). There are some protected (calculated) columns that I don't want users to enter data into. But I can't protect the sheet, because that prevents users from entering a new record at the bottom of the List. Does anyone have a suggestion on how to deal with this? I'm thinking of using an event macro invoked when user tabs out of say column C, which makes the selection skip the cell in column D and go directly to the cell in column E. I guess I'd have to use Worksheet.SelectionChange. But I don't know how to do...

Picture in Publisher
When inserting pictures in publisher the picture does not show. I can see the frame. The same thing when I load a publisher file created by someone else. All the inserted pictures does not show. View>pictures is set to detailed display. Any suggestions for a solution? -- Thor Read the third FAQ here http://ed.mvps.org/Static.aspx?=Publisher/FAQs -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx "Thor" <Thor@discussions.microsoft.com> wrote in messag...

validity of a cell
hi everybody, i want to set a cell so that only text (alphabet) can be written there. when someone try to write number there error message will come out.Please help. thank u One way, assume it is A1 that you use, do data>validation>allow>custom =ISTEXT(A1)*ISERR(--(A1)) won't obviously work for mixed letters and numbers like A2 which can be entered. -- Regards, Peo Sjoblom (No private emails please, for everyone's benefit keep the discussion in the newsgroup/forum) "melirus" <melirus@discussions.microsoft.com> wrote in message news:D7180552-315C-4DB4-...

append a string of text to all cells in a column?
Excel 2003 Is there a way to do this? The cells that I want to append to all contaio plain text. Thanks! ....Lisa Lisa Assuming column of text is A In B1 enter =A1 & "textstring" Double-click on the fill handle of B1 to copy down. Gord Dibben MS Excel MVP On Wed, 14 Feb 2007 17:37:14 -0500, "Lisa Hetherington" <gerry.lisa@sympatico.ca> wrote: >Excel 2003 >Is there a way to do this? >The cells that I want to append to all contaio plain text. > >Thanks! > >...Lisa > Thank you!! ....Lisa "Gord Dibben" <gorddibbA...

picture in picture
Have to digital pictures & would like to put a couple of people on one picture into the other picture. How do i do this? Anyone got any ideas? TIA "ted medin" <n6trf@arrl.net> wrote in message news:OaNwFXQeKHA.2596@TK2MSFTNGP04.phx.gbl... > Have to digital pictures & would like to put a couple of people on one > picture into the other picture. How do i do this? Anyone got any ideas? > TIA Well not with Vista. You need a Graphic editing application. The Gimp may be able to do this. (It's free, Open Source but is a bit tricky yo get to lear...

format cell #3
I have this in a cell; "2 vs 3" (without quotes), I want to find and replace it with "2 - 3" (without quotes). When I do this it either turns it into a date or a string of five numbers. I have formatted the cell to be "text" or "general" yet it still converts to a date or a string of numbers. I would appreciate any help, thank WAB WAB, Try replacing with '2 - 3. Using the single quote at the beginning will force to maintain the text. Don't worry, the sinqle quote will not show in the cell. HTH, Paul "wab" <anonymous@discus...

Formatting Cell #2
I have a block of text that I auto corrected and shows corrected in the Normal view. However, when I preview the sheet there is space between cell above it and the text in my cell. I want the text to come all the way up against the cell above it. How do I fix this? Format-Cells-Alignment tab. Set the vertical text alignment to "top." "Mike" <anonymous@discussions.microsoft.com> wrote in message news:2bedc01c46905$2321d7f0$a501280a@phx.gbl... > I have a block of text that I auto corrected and shows > corrected in the Normal view. However, when I preview t...

Picture Link
Appreciate some help here and thanks in advance. I link my pictures to the following folders C:\Documents and Settings\MyName\Desktop\Picture.jpg C:\Documents and Settings\MyName\My Documents\Picture.bmp My code: If Me!pic1a = "X" Then Forms!startpg!fmpPic!Img.Picture = "" Else Forms!startpg!fmpPic!Img.Picture = Me!pic1a End If It works on my PC but when I copied the program to another PC, it does not work. This is because of "MyName" and the other PC has a different name. Is there a way to ignore "MyName" for any PCs Regards "ChoonBoy&quo...

Sending pictures with text and then another picture with text.
I receive some e-mails with text and then a picture with more text and again a picture. Some of these will have 8 to 10 pictures with text under each picture. But when I send it out it is received with all of the text in a group and the pictures are all sent as attachments. How do I get my e-mails to send the pictures and text the way I receive them? Thanks for any help you can give me. Bob ...

blinking or flashing cell or cells
I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this possible? Possible? Yes. Recommended? No. Why? Slows down the processing time. But a search through the google archives yielded a lot of solutions. Here's one from MVP Chip Pearson: http://tinyurl.com/yw7md HTH Jason Atlanta, GA >-----Original Message----- >I want a cell or string of cells to flash or blink constantly when i open the spreadsheet. It does not matter if the text or background blink or flash. Is this...

Picture in header
How do I get a picture in the header? This was added in xl2002. File|Page setup|header/footer tab|custom header There's an icon that looks like a picture near the far right. Steve wrote: > > How do I get a picture in the header? -- Dave Peterson If you are using a version of Excel before 2002 then check out: http://www.nwarwick.co.uk/Excel2000GraphicalHeaders.htm for a workaround. HTH Neil www.nwarwick.co.uk "Dave Peterson" wrote: > This was added in xl2002. > > File|Page setup|header/footer tab|custom header > There's an icon that looks lik...

Extract data from a cell after a constant value
Howdy All, I have a spreadsheet that contains 1 column of data, if the cells of the column are the city names and populations of towns in the following format: Appleton, Wisconsin (WI) (pop. 70,087) The 'pop.' is always present. I want to extract just the population number (ie: 70,087) from these cells into another cell. What is the simplest way to accomplish this? Thank you, Brian On Sun, 19 Aug 2007 12:29:37 -0500, "Wolfman" <wolfmanx@charter.net> wrote: >Howdy All, > >I have a spreadsheet that contains 1 column of data, if the cells of the >...

Can pictures be centered in a picture frame in a catalog?
I have created a catalog for items we sell. I have added the pictures to the catalog through the Excel worksheet. When the worksheet is imported, all of the pictures left-justify in the picture frame. Can this be centered? ...

Cell colour according to date
Hi, Is there a formula that would change the cell colour if a date in a cell was out of date afetr a set number of years. Example: Cell B9 contained date 140506 I then want the cell B9 to turn red when the date reaches 2 years later 140508. Thanks in advance Jason Let's assume that your example date is 14 May 2006. Click on B9 and: Format > Conditional Formatting... > Formula Is > =TODAY()-B9>731 then pick the colour red. -- Gary''s Student - gsnu200773 Use conditional formatting with a formula of =DATE(YEAR(B9)+2,MONTH(B9),DAY(B9))<TODAY() -- --- HTH Bob ...

Updated cells
Our company goes through a budgeting process every year utilizing fairly complex Excel spreadsheets. These workbooks are sent out to the department managers shared so the changed may be merged when they are returned with their changes. This process of sending and returning is repeated numerous times thoughout the process. Everytime the workbooks are returned we upload into our SAP system. When a workbook is returned to me again...I only need to upload the cells that have CHANGED...which makes the upload process MUCH faster. How can I identify those cells that have had their values changed...

thumbnail in CListCtrl cell
Hi there, I've found ways to put icon in a CListCtrl (report view) cell. But when I tried to change the icon to a bitmap, which is bigger, the reults is just empty cell. Is there any way to enlarge the cell so that my bitmap could fit in? How about this source, http://www.codeproject.com/listctrl/ThumbsViewer.asp I made it and still have some problem in thread, I think it can help you. ...

attaching pictures as an icon
Hi I am trying to save memory in an excel report and I wish to include a picture in this report as an icon that shows the picture when selected. If you're going to try to save memory in the workbook, then it sounds like the big picture will be outside excel (a common LAN folder???). If yes, then maybe you could create thumbnails of each of your pictures (using ????) and then add a hyperlink to each thumbnail. The hyperlink would use whatever program is associated with the extension to open the big picture--outside of excel completely. (I don't know how you'd include the big p...

Counting cells with specific month in
How can I count the number of cells in date format which contain a certain month Example: A 1 01/10/2009 2 01/09/2009 3 20/09/2009 4 12/10/2009 How can I count the number of cells in column A which contain an October date. The answer here would be 2. Thanks Try this formula (set the month number, 10 in this case, as needed)... =SUMPRODUCT(--(MONTH(A1:A4)=10)) -- Rick (MVP - Excel) "JRD" <JRD@discussions.microsoft.com> wrote in message news:ED76B82C-3517-4C1E-AAE0-21C0DDC84E80@microsoft.com... > How can I count th...

How do i change the cells in a column at the same time in Excell?
Christar, You post is way thin on details and to insure you get some goo feedback, it is important to take the time to be a specific as possibl about what you want to happen. That being said; here is an example of changing an entire column' formatting.. If you want to apply the same formatting to all the cells in a column click on the column letter A,B,C........, you will notice that th entire column is highlighted. Now, go straight to Format>Cells an begin selecting the formatting changes you would like. These change will be applied to the entire selected column. Hopes this helps, ...