Excel Macros - Highlighting a Cell

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)

Static OldRange As Range

On Error Resume Next

Target.Interior.ColorIndex = 4' Specify the number for colour

OldRange.Interior.ColorIndex = xlColorIndexNoneSet OldRange = TargetEnd Sub

Session on Team

To bring back the team bonding, i conducted a session on teaming and what all of us need to do to bring in improvement. It was appreciated and the document was clear and precise.
Some Key Topics Covered:
-> Win as a Team
-> Are we bonded?
-> Are we on Track?
-> Are we leaders?
-> Are we Skilled?
-> Happening around
-> Are we really happy?
-> Thank you.
This perfectly helped me in motivating the team and bringing back the confidence. Can be tried out for your team also :)
Cheerz,
Jij

Windows 7 RC - First Bug

The first documented bug in the Windows 7 Release Candidate (build 7100) is a doozy.
Yesterday, Microsoft published Knowledge Base article 970789, which provides details of a problem that affects the 32-bit (x86) English-language version of Windows 7 build 7100. The problem, in short, is that the installer incorrectly sets access control lists (ACLs) on the root of the system drive. The longer version is described as follows:
In the English version of Windows 7 Release Candidate (build 7100) 32-bit Ultimate, the folder that is created as the root folder of the system drive (%SystemDrive%) is missing entries in its security descriptor. One effect of this problem is that standard users such as non-administrators cannot perform all operations to subfolders that are created directly under the root. Therefore, applications that reference folders under the root may not install successfully or may not uninstall successfully. Additionally, operations or applications that reference these folders may fail.
For example, if a folder is created under the root of the system drive from an elevated command prompt, this folder will not correctly inherit permissions from the root of the drive. Therefore, some specific operations, such as deleting the folder, will fail when they are performed from a non-elevated command prompt. Additionally, the following error message appears when the operation fails:
Access is denied.
Furthermore, the missing security descriptor entries protect non-admin file operations directly under the root.
A hotfix is available as an important update that should be delivered and installed automatically by Windows Update, assuming you have set up automatic updates. On one test system that I checked just now, the update had already been installed overnight. On two other systems, the update had been downloaded but was awaiting installation.
The hotfix package fixes the security descriptor of the root of the system drive, but it does not repair applications that are already installed, nor does it affect the permissions of folders that were created after the installation.

Windows 7 RC - Getting Started

What are the hardware requirements?
Actually, the hardware requirements for Windows 7 RC are relatively mild. I suppose that’s because Windows Vista has been out for over two years and we’ve all had time to get used to the idea of advanced hardware requirements from an operating system combined with the fact that hardware that was once deemed as a steep-and-expensive increase has become commonplace.
In any case, the minimum system requirements you’ll need for Windows 7 include:
DVD burner/drive
1 GHz or faster 32-bit (x86) or 64-bit (x64) processor
1 GB RAM (32-bit) / 2 GB RAM (64-bit)
16 GB available disk space (32-bit) / 20 GB (64-bit)
DirectX 9 graphics processor with WDDM 1.0 or higher driver
My test system, on which I installed the 32-bit version, has a DVD burner, AMD Athlon 64 X2 3800+ processor, 1 GB RAM, an NVIDIA GeForce 6100 nForce 405 onboard video, and plenty of disk space. (For this particular test system, I installed an additional SATA hard disk, switched the cables, and installed Windows 7 RC on it. When I need to switch back to Vista, I just shut down and switch the cables. While it may sound like a crude mechanism, it is relatively quick to make the switch due to the SATA connectors, and I can reformat and reinstall at will without having to worry about dismantling my Vista test configuration.)
Can anyone get in on the release candidate program?
In days gone by, you had to be signed up/registered in the testing program in order to take part in release candidate testing, but not with Windows 7 RC. In fact, Microsoft is treating the RC like shareware. Anyone can download it for free and use it for a limited time before actually purchasing it. However, instead of a 30-, 60-, or 90-day trial, Microsoft is giving you 300 days. On March 1, 2010, the RC will start shutting down every two hours and will completely stop working on June 1, 2010.
To get your free copy, just go to the Windows 7 Release Candidate Download page and follow the instructions. The RC will be available for download at least through July 2009, and Microsoft is not limiting the number of product keys.
What’s new in this version?
The short answer is plenty! If you’ve been following my blogs over the past few months, you already have an overview of many of the new features, such as a new Taskbar, Jump Lists, Aero Snap, Aero Peek, Problem Steps Recorder, file system Libraries, User Account Control Settings, and enhancements to Task Manager and Resource Monitor just to name a few. At this point, Windows 7 RC is said to be feature-complete, which means that everything that was planned is now in the operating system
One of the hottest new features being introduced as an add-on with the RC version is XP Mode, which will allow you to run older apps that work fine in XP but are incompatible with 7 in a virtual environment. XP Mode is based on Microsoft’s Virtual PC and runs Windows XP SP3 in a virtual machine. Keep in mind that XP Mode is available only with Professional, Ultimate, and Enterprise editions and requires that your CPU support hardware virtualization.
Other new features being introduced with the RC include BitLocker To Go, which extends the BitLocker drive encryption feature to USB removable drives. Another new security feature aimed at removable drives is actually something that Microsoft removed from the operating system — AutoRun. When you connect a removable drive, malware will no longer be able to piggyback off of AutoRun to launch its attack.
While not as crucial as some of the other features in the operating system, you’ll now find a plethora of new multimedia-based features, new sound schemes, new themes, and new desktop wallpapers, including a picture shuffle that changes your wallpaper every 30 minutes. And there’s much, much more…
Where can I learn more?
Of course, I’ll be covering Windows 7 RC in more detail in upcoming blogs, so you learn more right here at TechRepublic. You should also frequent Microsoft’s Windows 7 page and sign up for the Windows Vista and Windows 7 Report newsletter.

Windows Home Server at a glance

If you have multiple PCs with increasingly large amounts of digital photography, music, video, and documents, then protecting, organizing, and connecting this digital media can be a challenging task. Help with managing your digital dilemmas has arrived. Take a look.

1. Digital memories and media stored and organized in a central location
   Home computers backed up daily, automatically
   Simple restore of lost files or even entire hard drive contents
   Complete access to files from both inside and outside the home
   A secure and personalized website address for sharing photos and home videos
   Easily add storage space and new software capabilities
   

Windows Home Server Image Based Backup...

We all know that we should backup our computers in case of hard drive failure, disaster, or simple wear and tear. How often do we backup our important information and ensure the data is safe and available. Mostly we worry only when the data is lost. Windows Home Server and its automatic image based backup software technology, gives you peace of mind and the ability to quickly and easily restore your digital life even if your system have gone for a toss.

What is new in Exchange 2010????

Microsoft Exchange Server 2010 brings a new and rich set of technologies, features, and services to the Exchange Server product line. This topic lists many of the new features and functionality that are included in Exchange 2010

New Rights-Protected E-Mail Functionality with Active Directory RMS
New Transport and Routing Functionality
New Permissions Functionality
New High Availability Functionality
New Messaging Policy and Compliance Features
New Outlook Web Access Features
New Unified Messaging Features
Web Management Interface
New Exchange Core Store Functionality
New Administration Functionality in the Exchange Management Console
New Administration Functionality in the Exchange Management Shell