settimer

Hi, This is a vba code that hopefully accomplishes what the title of the thread says. Obviously, the forms must be modeless so that the user can freely move from one form to aanother. Problem is, using modeless forms makes this task difficult as we cannot subclass modeless forms to properly...

Hi all, Following a question I saw the other day, where it was asked if we could change the color of the Buttons in the standard vba MsgBox, I decided to give it a shot since I have never seen any code anywhere that addresses the issue. I have seen code before that sets the background color but...

Hi all, This is an attempt to simulate the Windows built-in screen-reader narrator but, done with vba alone. The code is supposed to read-back the type of object currently under the mouse pointer and, if applicable, to read the object caption\text\value as well. The code lets you choose a...

Hi all, I Have recently written this piece of code so I just thought I would post it here for future reference should anyone be looking for vba code to lock\unlock a vbaproject programmatically without needing to use the unreliable SendKeys method. workbook example This code requires that the...

I have a shared file on a LAN. I borrowed some code online to kick out idle users (who presumably forgot to get out of the file). I tweaked it a bit so that it puts them to read-only instead of kicking them out altogether (not sure if it exhibited the undesirable behavior I'm about to...

Workbook Demo Hi Excellers, As the title says, this is a Class that creates ToolTips for worksheet controls .. The tooltips are made out of office AutoShapes Some of its fun features : 1- Works for all controls except for Spin and ScrollBrar controls 2- You can create a tooltip for different...