Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default lock keyborad & mouse

Hello,

any macro to lock keyboard & mouse option so

other user could not change in file
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default lock keyborad & mouse

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 621
Default lock keyborad & mouse

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
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
How to lock the Ctrl key? (as locking the Shift key w/Caps Lock) Rick-cel Excel Discussion (Misc queries) 2 August 5th 09 06:45 PM
how do I undo the scroll lock, thscroll lock button does not work scroll lock Excel Discussion (Misc queries) 3 July 19th 08 10:17 PM
How can Excel vba detect if Caps Lock or Num Lock is on? abc[_6_] Excel Programming 2 December 2nd 05 06:14 AM
my mouse moves diagonally when i scroll on mouse? BKMISHRA Excel Worksheet Functions 0 June 29th 05 11:43 AM
moving mouse highlights cells without touching left mouse button bremboy Excel Discussion (Misc queries) 2 January 27th 05 06:19 PM


All times are GMT +1. The time now is 04:00 PM.

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

About Us

"It's about Microsoft Excel"