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
.
|