Enabling Outlining Commands on a Protected Worksheet
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
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
Introduction: This macro can be used to count how many files exist in a folder and subfolders. In addition, if passed the file extension, it can also be used to count only files of a specific type. (For example "xls"
Dave writes: I found your excellent code to run a procedure on a target spreadsheet from an originating spreadsheet on VB Express Forum. Â It works fine if both files are on the same jump drive but fails on our work
On Friday night, I began reading my way through PED 2nd Edition. After something weird happened with Excel, (I think because I have Excel 2003 and 2007 installed,) I got the bright idea to create a very simple Windows Forms
A little background 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
Macro Purpose: This code quickly replaces all external links in an Excel workbook with their values. It is something that can be very handy when you need to send a heavily linked workbook outside of your immediate network, to a
I had to do some real quick budgeting work today, and needed to build a template to work from. The easiest way was to grab a heavily linked workbook we had, and convert all the links to values so that
I tripped on this in a forum today... The user wanted to create a message for all cells that did not have any cells dependent on their target. The set about doing this by using the Trace Dependents tool through
I received a question from a reader of my site about how to adapt my Print Multiple Worksheets to Multiple PDF Files article so that it would also print each file to two separate directories. There are at least a
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.