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 following article is courtesy of Yoav Ezer, who volunteered to do a guest post for me while I am at the summit. Thanks Yoav! User Defined Functions versus Formulas in Excel Which are better, Excel functions or UDFs? Use
Tonight I had to do some work on my financial model from home. Naturally, I copied the files into my "work stuff" folder on my laptop hard drive, and headed out at the end of the day. But as I
Clark asks: I am trying to copy two different operations into a "This workbook". One is the "disable cut copy paste" function that I found and the other is the "force user to enable macros" so that the disable cut
After all my evangelizing (or complaining if you like), I think it's important to acknowledge when someone does/announces something that addresses my concerns. Post titles are the first things that come up in search engines. So if someone is searching
Yesterday Rob Collie made a post on his blog about sizing considerations for PowerPivot implementations on Sharepoint. The main thrust of the post was directed at end users and making sure that their server farms have adequate resources to efficiently
I was working on a little application which has a spin button on the worksheet. That spin button is linked to a cell and works just fine for my purposes. After a while though, it became apparent that I needed
I have a financial model that I set up using a grouping in some key places so that I could collapse sections of the model when I didn't want to look at them. As I was handing off the model
Today I realized that one of my GETPIVOTDATA formulas was returning an error, since there wasn't any result in the Pivot Table it was checking for data. Unfortunately, during the design of the spreadsheet I never wrapped the function with
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
