MoDCore

Working out SLA Breaches with Excel!

Looking for a simple way to keep track of task and dates? This will help you keep track of SLA's...

Show and hide sheets based on user

This is a handy bit of code for a simple show and hide command, using the "Windows Username in a...

Dynamically Change Pivot Table Source Data

Dynamically Change Pivot Table Source Data This is a handy bit of code which will save you having to update...

Add desktop shortcut to URL – VBS

This is a simple VBS script that will add a desktop shortcut for a URL to a users PC. Change...

Forums

Data Processing

Here is place that will be updated with Data processing scripts and tips. IF statement The if statement can be...

Use Buttons to Navigate Sheets

This a quick simple way to show how to use buttons to navigate the on the to different worksheets. From...

Windows 7 – Turn off Task Bar Grouping

Turn off Task Bar Grouping in RegEdit This will show you how to turn off Windows 7 taskbar group if...

Open Internet Explorer Once or Loop – VBA

You can attach this code to a button that can open Internet Explorer and navigate to a set website. Sub...

Fun and Pranks

Here is a couple of fun/pranks that are for VBS or VBA in excel. Do you have any you want...