|
|
Thursday, January 2, 2003 |
Excel tip: If you create a macro in a workbook, Excel may be set to pop up a message when you open that workbook that asks you if you want to enable or disable macros. If you delete that macro later, Excel may continue to prompt you that the workbook has macros, even though it doesn't appear to. This is because the VBA module that contained the macros is still around.
To remedy this, hit Alt-F11 to launch the VBA editor. In the Project Explorer on the right, find your workbook and the Modules folder. Open the Modules folder and look for any modules. (Most of the time, the generic module will be Module1.) Left click on it to see if there are any macros left. If there aren't, you can safely delete the module by right clicking on it in the Project Explorer and selecting "Remove Module1" from the pop-up menu. Save your spreadsheet. The next time you launch, Excel will not prompt you to enable or disable macros!
5:28:52 PM
|
|
Blogging at Work: Alternative to Broadcast Emails
Jeff has exposed a cool alternative to broadcast emails today. In his work blog he announced that he was making a change on a server today. I was struck with what a nice change this is from broadcast emails. Since it comes in my News Aggregator instead of my inbox, I don't have another message to sort through (well, the News Aggregator can be a bit much to sort through, but that's a different problem). Also, if I weren't interested or working on the same projects as Jeff, I may not be subscribed to his feed at all. Finally, since I have permanent access to Jeff's content, I can let him store that content as part of his blog and I don't have to keep the email message around. I can reference his blog whenever I want to see it.
Jeff had brought up the concept of replacing broadcast emails with blog (or k-log?) subscriptions a couple of weeks ago. It sounded good then, but to see it in practice is extremely gratifying.
12:41:59 PM
|
|
© Copyright 2004 Tom Pierce.
|
|