If you'd like to prevent anyone from printing your workbook, this code will do the trick (subject to the caveat below). Macro Weaknesses: If someone disables macros, your code will not run Versions Tested: These macros have been tested with
My staff and spreadsheet users will tell you that any time I build a spreadsheet, there are always shaded cells on the grid. I preach that "Green means go", and make sure that any cell they enter data in has
The only thing that can't be automated in Excel is the input of raw data... and even that can sometimes be done. If you are looking to avoid repetitive tasks in your Excel spreadsheet (clearing out data to start a
ExcelGuru.ca is run by Ken Puls, FCPA, FCMA. I'm a Certified Management Accountant, who never remembers life without spreadsheets and computers. Since mid 1999, my career has been spent in the hospitality and tourism industry, in the finance and IT
I was working with some budget stuff today and wanted to forecast that a range of accounts would be written off. I had a forecast that showed the projected transactions monthly, (all zeros as the projects have been discontinued,) and
I love this! If you're running Outlook 2010 and Exchange 2010, you can set up your out of office replies any time during the day, and schedule them to take effect for a certain period. I wish I could do
Back in the days of classic Excel (versions 97 through 2003), I displayed about 10 toolbars, working out to hundreds of commands represented by tiny icons. We recognized them, and were able to have all of our most used commands
In Introduction to the Excel WebApp, we learned how to create, upload and view files in Microsoft's Web Version of Excel, hosted on SkyDrive (a free offering from Windows Live.) It should be noted that thee main reason for creating
In June 2010, Microsoft released the Excel WebApp as part of their Windows Live offerings. This is an interesting product as it allows you to store, read, edit and share your Excel document in the cloud. This means that it
Over the past while we've been building a Dashboard report for our golf course. It's got some historical information in it, but we've also pulled in things like weather forecasts. The intention is that our managers will be able to
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
