Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing users from changing macros | Excel Discussion (Misc queries) | |||
Preventing other users from opening hidden worksheets | Excel Discussion (Misc queries) | |||
Preventing users from unsharing a workbook | Excel Discussion (Misc queries) | |||
Preventing users from saving a spreadsheet | Excel Discussion (Misc queries) | |||
Preventing users from deleting worksheets | Excel Programming |