CONDITIONAL BREAKPOINTS
You CAN'T SET conditional breakpoints in Excel VBE...but you can SIMULATE one with the if statement.
PRIVACY WARNING WHEN SAVING WORKBOOKS
Privacy warning: This document contains macros, ActiveX controls, XML expansion pack information, or Web components. These may include personal information that cannot be removed by the Document Inspector.
How to I get rid of this tripe?
Excel Option > Trust Center > Trust Center Setting > Macro Settings > click Enable All Macros ....
Excel Option > Trust Center > Trust Center Setting > Active X Settings > click Enable All controls without restriction ....
EXCEL 2007 CLAIMS TO DO MULTI-CORE CALCULATION
Where is this functionality at the VBA level.
NO VOLATILE KEYWORD IN EXCEL VBA
Boo!
NO NOTION OF CLOSURES IN BUILDING WORKSHEET FUNCTIONS
Closures would be real useful when implementing mathematical models in Excel.
No comments:
Post a Comment