Nuke Modified | AntiVirus Remover

Excel VBA – ‘Ontime’ with shared workbook?

I have some code that displays alarms (via a message box) at certain times by use of the ‘OnTime’ function ( in conjunction with WorkBook_Open). The problem I have is that the workbook is shared as I want anyone with it open to receive the alarm, but what happens is the alarm works for the first person who opens the sheet, but users who open later receive an error message at the time of the alarm. Any ideas?

Please post your WorkBook_Open macro so we can see exactly what’s going on.

Excel VBA Macro Programming by Shepherd, Richard Edition ILL, 1 $38.49 Part I: Programming in Excel VBA 1: The Basics 2: Variables, Arrays, Constants, and Data Types 3: Modules, Functions, and Subroutines 4: Programming Basics: Decisions and Looping 5: Strings and Functions and Message Boxes 6: Operators 7: Debugging 8: Errors and the Error Function 9: Dialogs 10: Common Dialog Control 11: Command Bars and Buttons Part II: Object Models 12: The Excel Object Model 13: The Excel Object Model-Main Objects 14: Using Excel to Interact with Other Office Programs Part III: Advanced Techniques in Excel VBA 15: Charts and Graphs 16: Working with Databases 17: API Calls 18: Class Modules 19: Animation Part IV: VBA in Action 20: Converting Labels to Numbers and Numbers to Labels 21: Transposing a Range of Cells 22: Adding Formula Details into Comments 23: Calculating a Range 24: Reversing a Label 25: Who Created the Workbook? 26: Evaluating a Cell 27: Sorting Worksheets into Alphabetical Order 28: Replacing Characters in a String 29: Timed Events 30: Auto Totaling a Matrix of Numbers 31: Absolute and Relative Formulas 32: Coloring Alternate Rows and Columns of the Spreadsheet 33: Coloring Cells Containing Formulas 34: Summing Cells by Reference to a Master Cell 35: Globally Changing a Range of Values 36: Displaying Hidden Sheets Without a Password 37: Searching Multiple Sheets and Workbooks 38: Brighten Up Your Comments 39: An Alternative to Message Boxes 40: Working with Shapes 41: Turning Your VBA Code into an Add-In A: ASCII Character Codes

Excel 2007 VBA Macro Programming by Shepherd, Richard Edition ILL, 2 $27.49 Part I. Programming in Excel VBA; Ch. 1. The Basics; Ch. 2. Variables, Arrays, Constants, and Data Types; Ch. 3. Modules, Functions, and Subroutines; Ch. 4. Programming Basics: Decisions and Looping; Ch. 5. Strings and Functions and Message Boxes; Ch. 6. Operators; Ch. 7. Debugging; Ch. 8. Errors and the Error Function; Ch. 9. Dialogs; Ch. 10. Common Dialog Control; Ch. 11. Command Bars and Buttons; Part II. Object Models; Ch. 12. The Excel Object Model; Ch. 13. The Excel Object Model–Main Objects; Ch. 14. Using Excel to Interact with Other Office Programs; Ch. Part III. Advanced Techniques in Excel VBA; Ch. 15. Charts and Graphs; Ch. 16. Working with Databases; Ch. 17. API Calls; Ch. 18. Class Modules; Ch. 19. Animation; Ch. 20. Working with XML Files; Ch. 21. The Ribbon; Ch. 22. Pivot Tables; Part IV. VBA in Action; Ch. 23. Converting Labels to Numbers and Numbers to Labels; Ch. 24. Transposing a Range of Cells; Ch. 25. Adding Formula Details into Comments; Ch. 26. Calculating a Range; Ch. 27. Reversing a Label; Ch. 28. Who Created the Workbook; Ch. 29. Evaluating a Cell; Ch. 30. Sorting Worksheets into Alphabetical Order; Ch. 31. Replacing Characters in a String; Ch. 32. Timed Events; Ch. 33. Auto-Totaling a Matrix of Numbers; Ch. 34. Absolute and Relative Formulas; Ch. 35. Coloring Alternate Rows and Columns of the Spreadsheet; Ch. 36. Coloring Cells Containing Formulas; Ch. 37. Summing Cells by Reference to a Master Cell; Ch. 38. Globally Changing a Range of Values; Ch. 39. Displaying Hidden Sheets Without a Password; Ch. 40. Searching Multiple Sheets and Workbooks; Ch. 41. Brighten Up Your Comments; Ch. 42. Importing a CSV File Containing Leading Zeros; Ch. 43. Working with Shapes; Ch. 44. Turning Your VBA Code into a Add-In; Appendix. ASCII Character Codes; Index

Excel VBA 24-Hour Trainer by Urtis, Tom Edition ILL, 1 $19.49 This unique book-and-DVD package helps even non-programmers extend Excel with VBAVirtually every manual task in Excel can be automated with VBA, which increases your productivity and saves enormous amounts of time. This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate many routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons and illustrations, while the accompanying DVD provides demos and screencasts to complement each lesson.Introduces you to programming with Visual Basic for Applications (VBA), macro composition, and the programming environmentExplains events programming, embedded controls, user forms, message boxes, input boxes, looping, and moreShows you how to control other Office applications from Excel, such as Word, Outlook, Access, and PowerPointIncludes enhanced coverage of each lesson on the DVD, which also offers detailed examplesProvides ideas for applying VBA to everyday tasks in a way that’s both practical and funUse this book-and-DVD package to get the total learning experience of VBA for Excel!

Excel 2003 Power Programming with VBA (Mixed media product) $74.12 "Today, no accomplished Excel programmer can afford to be without John’s book. The value of Excel 2003 Power Programming with VBA is double most other books–simultaneously the premier reference and best learning tool for Excel VBA." —Loren Abdulezer, Author of Excel Best Practices for Business Everything you need to know about: Creating stellar UserForms and custom dialog box alternatives Working with VBA subprocedures and function procedures Incorporating event-handling and interactions with other applications Building user-friendly toolbars, menus, and help systems Manipulating files and Visual Basic® components Understanding class modules Managing compatibility issues Feel the power of VBA and Excel No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away. CD-ROM Includes Trial version of the author’s award-winning Power Utility Pak Over one hundred example Excel workbooks from the book System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. Microsoft Excel 2003. See the "What’s on the CD" Appendix for details and complete system requirements.

Excel 2003 Power Programming with VBA by Walkenbach, John Edition ILL, 1 $33.99 Today, no accomplished Excel programmer can afford to be without John’s book. The value of Excel 2003 Power Programming with VBA is double most other books-simultaneously the premier reference and best learning tool for Excel VBA.–Loren Abdulezer, Author of Excel Best Practices for BusinessEverything you need to know about:* Creating stellar UserForms and custom dialog box alternatives * Working with VBA subprocedures and function procedures * Incorporating event-handling and interactions with other applications * Building user-friendly toolbars, menus, and help systems * Manipulating files and Visual Basic components * Understanding class modules * Managing compatibility issuesFeel the power of VBA and ExcelNo one can uncover Excel’s hidden capabilities like Mr. Spreadsheet himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.CD-ROM Includes* Trial version of the author’s award-winning Power Utility Pak* Over one hundred example Excel workbooks from the bookSystem Requirements: PC running Windows 2000 SP3 or later, or Windows XP(TM) or later. Microsoft Excel 2003. See the What’s on the CD Appendix for details and complete system requirements.

Excel VBA Programming For Dummies by Walkenbach, John Edition ILL, 1 $21.49 Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more.This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes:An introduction to the VBA languageA hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing itThe essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorderThe essential VBA language elements, including comments, variables and constants, and labelsWorking with Range objects and discovering useful Range objective properties and methodsUsing VBA and worksheet functions, including a list and examplesProgramming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loopAutomatic procedures and Workbook events, including a table and event-handler proceduresError-handling and bug extermination techniques, and using the Excel debugging toolsCreating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricksCustomizing the Excel toolbarsUsing VBA code to modify the Excel menu systemCreating worksheet functions and working with various types of argumentsCreating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilitiesAuthor John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with:A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changesInformation to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to knowWhat are you waiting for? Sure, learning to do VBA p