lock keyborad & mouse

[kalpesh]

Hello

any macro to lock keyboard & mouse option s

other user could not change in file

 

[GS]

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
Tools>Protection 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]

Make file read-only and changes cannot be made.

Or Protect workbook and worksheets.


Gord