View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Phillip Topping Phillip Topping is offline
external usenet poster
 
Posts: 3
Default Preventing users to move object in the sheet

Dusan,
If you protect your worksheets, (including objects), users
will not be able to move/change the charts etc. You might
want to use a password though because they can still turn
protection off and start fiddling...as they do..

Phillip

-----Original Message-----
Hello there,
I've made an excel application containing various objects
like buttons, graphs, scroll bars ect. and now I'd like

to:

1. in case graphs
- make them just visible but not selectable to prevent

the users to delete
or move them

2. in case of buttons, combo boxes etc.
- make them available but not movable, changeable


Thank you very much

Dusan


.