+ Reply to Thread
Results 1 to 5 of 5

Can't get no sleep...

  1. #1
    Registered User
    Join Date
    09-22-2012
    Location
    london, england
    MS-Off Ver
    Excel 2011
    Posts
    25

    Question Can't get no sleep...

    Hi, does anyone clever know an easy way to put the computer to sleep with vba code?

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,104

    Re: Can't get no sleep...

    Hi

    Thats a really cute thread title, but please gave your thread a title that actually describes what your requirement/problem is
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    12-27-2012
    Location
    cebu, Philippines
    MS-Off Ver
    Excel 2016
    Posts
    210

    Re: Can't get no sleep...

    i found this at the web.. i tried it.. and it works!


    Please Login or Register  to view this content.

    just paste any of those or all of those in a module in any excel workbook... i have excel 2007 and it worked!.. save the workbook first before testing.. then click my star if it works...
    don't worry, there's a lot of people that are far more confused than you
    but if you liked what i suggested. Click for me the "Add Reputation" - that way, we'd be both happy.

  4. #4
    Registered User
    Join Date
    09-22-2012
    Location
    london, england
    MS-Off Ver
    Excel 2011
    Posts
    25

    Re: Can't get no sleep...

    Cheeze!

    Yes I saw that as well. But it doesn't have a sleep code unless it is GLOBAL CONST....=3.

  5. #5
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Can't get no sleep...

    and if you're using Excel 2011 it won't work at all ;-)
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sleep function
    By Slyone2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2010, 02:36 PM
  2. sleep vs wait
    By ilkamalo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2010, 03:28 PM
  3. Problem with wait/sleep
    By johngillespie in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-14-2007, 09:56 AM
  4. Calculating Sleep
    By CarlM in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-03-2006, 08:45 AM
  5. [SOLVED] Baby Sleep log
    By Baby's Sleep Log in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-02-2006, 03:25 PM

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