VBA – Macros

/VBA – Macros

VBA & DropBox causing Excel to crash on close

Excel Warning Box By Wyn Hopkins In a nutshell: Save yourself a lot of wasted time and turn off DropBox badges.... If you ever experience a VBA Password box appearing after you close Excel and then the dreaded "Microsoft Excel has stopped working" message then there may be a simple solution...... After much debugging [...]

VBA – Macros|

58 Crazy Excel Stories (that are probably happening in your company right now)!

58 Crazy Excel Stories (that are probably happening in your company right now)! Crazy things happen when you mix untrained users with Excel. It’s not really rocket science.  Crazy things would happen with any complex system if you don’t train people properly. But many companies simply assume that everyone knows Excel, so they [...]

 Hiding And Unhiding Sheets

Hiding and unhiding sheets I hide a number of sheets in the workbooks I create because they are used for workings. Is there an easy way to make them all visible at once? By Neale Blackwood The following macro will unhide all the sheets in the active workbook.: Sub UnHideAllSheets() 'this macro unhides all [...]

VBA – Macros|

 Save All Open Files

Save All Open Files I work with a model that has many files and links between the files. When I make structural changes that affect links I have to go through and save all the open files to make sure the changes are kept. Is there a way to save all the open files [...]

VBA – Macros|

 Link Sheet Name To Cell Value

Link sheet name to cell value Is it possible to link the sheet name to a cell's contents? I want the sheet name to be whatever I enter into cell A1. By Neale Blackwood There is no built-in Excel function or feature to do this. You have to use an event macro. The macro below [...]

VBA – Macros|

 List Of Sheets With Hyperlinks

List of sheets with hyperlinks I regularly create a list of sheets in a contents sheet in my files. I then create hyperlinks to the sheets. Can this process be automated? By Neale Blackwood The macro below will create a list of all sheets in the current workbook. This list will start at the [...]

VBA – Macros|

 Full Path Name In Footer

Full Path name in Footer How can I put the full path name of my file in the footer without typing it? By Neale Blackwood Excel XP and 2003 allow you to easily insert the full path in your footer using the Page Setup, but unfortunately earlier versions don't. In Excel 97 and 2000 [...]

Functions, VBA – Macros|

 Hiding And Unhiding Quickly

Hiding and unhiding quickly I frequently hide and unhide the same sets of rows in my sheet, so that the detail doesn't print on my reports. Is there an easier way to do this? By Neale Blackwood The feature that would make hiding and unhiding specific rows easier is called Group. Select the rows [...]

Formatting, VBA – Macros|

 Protect And Unprotect Sheets Macro

Protect and unprotect sheets macro I frequently protect sheets without using a password to ensure users don't accidentally change something they shouldn't. Is there an easy way to unprotect all the sheets in a workbook and then protect them again? By Neale Blackwood There is no built-in method to protect or unprotect all the [...]

VBA – Macros|