So here’s a new post on something I’ve been using for years. A simple actionlist that has grown to a tool I use very often. Maybe ‘tool’ sounds complicated, but it really isn’t, I guess thats part of why I like it so much. So what is it? In its essence its a way of working to get your project meetings done efficiently. As a side effect I created a spreadsheet with several tabs for listing actions, issues, risks and the like for a project. Over the years it changed to reflect my way of working, so maybe its better to elaborate on that before explaining the sheet. Continue reading
Often if procedures are called from existing code they change these settings, which makes it hard to track the current settings when a call returns. This code provides a stack to be used for Excel Application based settings, it provides two base functions; Push and Pop. The Push function stores the provided settings (or current settings for all optionals left blank) and sets them. Upon Pop, the previous settings on the stack are restored.
Here’s another post of something I created long ago, yet never got to post. Just trying to catch up here
While looking for a control myself to achieve this, I couldn’t find any. Some VB6 controls we’re available, yet when distributing spreadsheets or databases I just don’t like to create to much dependencies on external controls. Quite often the support required goes through the roof when external dependencies are used.
Often if you create an Excel workbook with some automation features, you want to make sure that users enable macros to be sure the workbook behaves as designed. You can built in as many verification features as you want, but if the macros are disabled, they just won’t work.