Do you know these situations when you made some kind of a form in Excel, password protected the workbook, sheets and/or even VBA access…and months later people ask for password in order to modify it? This is were trouble starts – how should I know what password I used months ago and, of course, I did not share it ;-).
Since I had this situation several times at work, herewith – more as a reference for myself – a short walkthrough how to regain access to your VBA project . [Read more »]
Since we had this topic for several times within our team and people kept making fun of me because I like it nice & shiny…even in my spreadsheets…herewith a short explanation on how to customize the color palette in Excel 2003 and re-use adapted palette in other workbooks.