ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   lock keyborad & mouse (https://www.excelbanter.com/excel-programming/445400-lock-keyborad-mouse.html)

kalpesh

lock keyborad & mouse
 
Hello,

any macro to lock keyboard & mouse option so

other user could not change in file

GS[_2_]

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



Gord Dibben[_2_]

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



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com