Results 1 to 6 of 6

Application Onkey Problems

Threaded View

  1. #1
    Valued Forum Contributor realniceguy5000's Avatar
    Join Date
    03-20-2008
    Location
    Fl
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    951

    Application Onkey Problems

    Hi,

    I have a small problem and was hoping someone could point me in the right direction.

    I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button) any ideas why?

    Thank You, Mike

    Private Sub Workbook_Activate()
          Application.OnKey "{42}", "TEST"
       End Sub
    Private Sub Workbook_Deactivate()
        Application.OnKey "42"
    End Sub
    Last edited by realniceguy5000; 12-30-2009 at 09:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1