Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Chaplain Doug
 
Posts: n/a
Default 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   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

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   Report Post  
CyberTaz
 
Posts: n/a
Default

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
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
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? g wills New Users to Excel 3 February 17th 05 10:23 PM
Graphic in Header scaling with pages contents Shannon Broskie Excel Discussion (Misc queries) 0 February 15th 05 09:29 PM
make hidden window or workbook visible without specify the name mango Excel Worksheet Functions 1 December 30th 04 03:05 PM
make a cell empty based on condition mpierre Charts and Charting in Excel 2 December 29th 04 01:01 PM


All times are GMT +1. The time now is 06:53 PM.

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

About Us

"It's about Microsoft Excel"