IntroductionGetting StartedAll PostsNotesAbout The Author
Tuesday, June 23, 2009
RSS
Managing Excel's Application Settings
Tuesday, June 23, 2009 - 9:54 AM
If you've ever developed a complex spreadsheet that was driven at least in part by event macros, you'll see the usefulness of this code immediately. If not, then you may not want to use SubStart and the related subs (yet), but you may still want to use the SetApp and TestApp functions. "SetApp(All,TurnOn)" is an easy way to reset all Excel application settings, for example.

SubStart may be used only in your main procedures (including some event macros), or it may be used in all of your
Deleting Code With Code
Tuesday, June 23, 2009 - 9:23 AM

This will delete all code from one or more vb components (ie, worksheet and workbook objects and vba modules). It could be altered to delete specific procs, but this is useful for such things as deleting one or more modules of code and/or event macros from a file while converting it to an email attachment.


Private Sub DeleteCode(VBComponentNames)
'can use 'ALL' (a global constant, "ALL") for argument to delete code from all components (excel objects and modules)

    On Error
2 records total        

January, 2009
February, 2009
March, 2009
April, 2009
May, 2009
June, 2009
July, 2009
August, 2009
September, 2009
October, 2009
November, 2009
December, 2009
IntroductionGetting StartedAll PostsNotesAbout The Author