| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to lock the Data Controls' location from being altered by othe
hi,
I have created a command button on one of my MS Excel worksheet, but I don't wish that others could be able to alter my command button's location; let's say I want the command button to be placed on 150 (top), 150 (left). Although I have tried to use the protection feature offered in Visual Basic Editor; but this only can protect others from viewing the codes & the properties of the button, others still can move the button using mouse click & drag!!!! Is there any way that the location of the button can be locked???? Please advice if anyone out there has any ideal to do so..... Thanking in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock location of sheet within a spreadsheet | Excel Discussion (Misc queries) | |||
| how to limit the Weightage of any data & distribute excess to othe | Excel Worksheet Functions | |||
| need formula to return data from one column after comparing 2 othe | Excel Worksheet Functions | |||
| How do I lock the location of the Data Validation Input Message? | Excel Worksheet Functions | |||
| Lock a file so it can't be altered unless saved as another file | Excel Worksheet Functions | |||
Threaded Mode
