Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
any macro to lock keyboard & mouse option so other user could not change in file |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
kalpesh used his keyboard to write :
Hello, any macro to lock keyboard & mouse option so other user could not change in file This is a really BAD idea! I suggest you 'Protect' the sheets and the workbook to prevent users from making changes. You can do this via ToolsProtection in XL2003 and earlier, or via the 'Changes' section on the 'Review' tab of the Ribbon in XL2007 and later. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Make file read-only and changes cannot be made.
Or Protect workbook and worksheets. Gord On Sat, 18 Feb 2012 11:03:15 -0600, kalpesh wrote: Hello, any macro to lock keyboard & mouse option so other user could not change in file |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) | Excel Discussion (Misc queries) | |||
how do I undo the scroll lock, thscroll lock button does not work | Excel Discussion (Misc queries) | |||
How can Excel vba detect if Caps Lock or Num Lock is on? | Excel Programming | |||
my mouse moves diagonally when i scroll on mouse? | Excel Worksheet Functions | |||
moving mouse highlights cells without touching left mouse button | Excel Discussion (Misc queries) |