Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Preventing users from changing macros JS101 Excel Discussion (Misc queries) 2 February 9th 09 11:54 PM
Preventing other users from opening hidden worksheets pjk@boro Excel Discussion (Misc queries) 3 May 31st 08 12:25 AM
Preventing users from unsharing a workbook Cillian Excel Discussion (Misc queries) 0 December 1st 05 05:35 PM
Preventing users from saving a spreadsheet MDH Excel Discussion (Misc queries) 4 July 6th 05 09:46 PM
Preventing users from deleting worksheets Alice[_3_] Excel Programming 2 November 13th 03 07:38 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"