Preventing users to move object in the sheet
 

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

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


.