Tom Pierce's Blog : Let the geek times roll.
Updated: 6/20/04; 3:00:23 PM.

 

Subscribe to "Tom Pierce's Blog" in Radio UserLand.

Click to see the XML version of this web page.

Click here to send an email to the editor of this weblog.

 
 

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    comment []

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    comment []

© Copyright 2004 Tom Pierce.



Click here to visit the Radio UserLand website.

 


January 2003
Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  
Dec   Feb

Search

[sgl dagger]
How this works

Emacs Sources
 tsql-indent.el
 user-add-sql-folding-marks
 remove-line-boundary-in-region
 convert-camel-to-underscore

My Subscriptions
 Funny
 KM