How to Make Graphic Uneditable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2003. I have created a "switchboard" type menu on an Excel worksheet,
with controls and graphics. Before I put this out for general use, I would
like to make it so that a user cannot go into design mode on the workbook and
whenever a user clicks on one of the graphics, the "handles" (the things that
allow one to resize, move, etc. the graphic) or whatever they are called do
not appear. How do I accomplish these things. Thanks for the help
 
Doug,

Can you not use Tools - Protection - Protect sheet, with a password? It's
not difficult to crack (there are cracking programs out there), but it keeps
the honest people out.
 
Hi Doug-

How about Tools>Protection>Protect Sheet and put checks in whatever boxes
required by your sheet. Just make sure to _not_ check the box for Edit
Objects.

HTH |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Graphic to Multiple Worksheets 2
graphics properties changes when opening Excel 1
Can you use a macro to insert a graphic? Or apply a template? 2
Best method / software for graphical output from dynamic excel data 0
Behavior of text in cells..... 1
Converting Excel to pdf without the graphics on excel moving 1
How to best select from image and print full size? 1
How can I assign a macro to a graphic object on the worksheet 1

Back
Top