Preventing users to move object in the sheet

[Dusan]

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

 

[Phillip Topping]

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