How to prohibit the using of SHIFT key using VBA

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.

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