How to prohibit the using of SHIFT key using VBA

beginner · #1 04-11-2013, 02:42 PM

Does anyone have VBA code
How to prohibit the use of SHIFT key using VBA when opening excel file
VBA code I want put in Workbook_Open()

macropod · #2 04-12-2013, 07:42 PM

You cannot do that. If it was possible, virus writers could destroy your files. People can prevent you macro from running in other ways too (eg via their macro security settings or by starting Excel in safe mode). You cannot stop the users doing any of these things.

beginner · #3 04-12-2013, 11:33 PM

Quote:

Originally Posted by macropod

You cannot do that. If it was possible, virus writers could destroy your files. People can prevent you macro from running in other ways too

Thank you for answering

niton · #4 04-14-2013, 04:38 AM

Quote:

Originally Posted by beginner

Does anyone have VBA code
How to prohibit the use of SHIFT key using VBA when opening excel file
VBA code I want put in Workbook_Open()

You can try forcing users to enable macros.

Hide all sheets on closing. Except for a prompt sheet telling them to enable macros.

Code:

For Each Sheet In Sheets 
    If Not Sheet.Name = "Prompt" Then 
        Sheet.Visible = xlSheetVeryHidden 
    End If 
Next

Unhide on opening, if macros are enabled.

Code:

For Each Sheet In Sheets 
    If Not Sheet.Name = "Prompt" Then 
        Sheet.Visible = xlSheetVisible 
    End If 
Next 

Sheets("Prompt").Visible = xlSheetVeryHidden

http://www.vbaexpress.com/kb/getarticle.php?kb_id=578

*******************
Consider rating the thread by going to the "Rate Thread" dropdown.

macropod · #5 04-14-2013, 07:42 AM

I have already provided the OP with code to apply that kind of control (and more) in an earlier thread: https://www.msofficeforums.com/excel...t-working.html

beginner · #6 04-17-2013, 10:48 AM

@niton: Thanks for the advice
@macropod: Thank you for your response and the link, I saw it and now I study

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Noob here - I need a shift calendar by days with count of shift.	freeman	Excel	8	09-12-2012 08:45 AM
Shift cell right	gsrikanth	Excel Programming	2	01-17-2012 11:29 PM
All text shift to the left???	ewallet	Word	1	06-21-2011 08:41 AM
Shift key erratic	Razz	Outlook	2	05-04-2011 05:35 PM
Word 2003 Shift F3	FLMT	Word	0	02-22-2009 08:11 AM