Adding VBA Code For The First Time User
It's always nice when you go to a forum and someone gives you a nice bit of VBA code that is supposed to accomplish your goals. But if you've never used VBA code before, it's kind of hard to know
It's always nice when you go to a forum and someone gives you a nice bit of VBA code that is supposed to accomplish your goals. But if you've never used VBA code before, it's kind of hard to know
Over several years of participating in forums, and working on my own projects, I always felt it was a bit awkward to create and send new emails through Excel. Invariably, every time I found that I needed email code, I
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
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
