Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to Make Graphic Uneditable
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 -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
#2
|
|||
|
|||
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. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Chaplain Doug" wrote in message ... 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 -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
#3
|
|||
|
|||
Hi Doug-
How about ToolsProtectionProtect Sheet and put checks in whatever boxes required by your sheet. Just make sure to _not_ check the box for Edit Objects. HTH |:) "Chaplain Doug" wrote: 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 -- Dr. Doug Pruiett Good News Jail & Prison Ministry www.goodnewsjail.org |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |