|
ScaVBA, Developer, Securing your Excel macro file
Prevent your 2007 Excel file from running on any computer other than the specified one...
Adding demo version to your Excel macro file that will run for certain number of times then stop running ...
details
|
|
Views: 242
|
|
Downloads: 42
|
|
UI: En
|
|
Since: 9/11/2009
|
|
|
ScaVBA, Light, Securing your Excel macro file
Prevent your 2007 Excel file from running on any computer other than the specified one...
Adding demo version to your Excel macro file that will run for certain number of times then stop running ...
details
|
|
Views: 265
|
|
Downloads: 38
|
|
UI: En
|
|
Since: 9/11/2009
|
|
|
Download protected images from Flickr.com
Some images on Flickr.com you cannot download, and if you try, you will have a blank image. (Named Spaceball.gif)
Here is the Excel file that enables you to see the image itself out of Flickr ...
details
|
|
Views: 479
|
|
Downloads: 56
|
|
UI: En
|
|
Since: 7/24/2009
|
|
|
Process User Commands on Rows
Here is the one that will do the three basic operations on an entire row in a sheet, the operations are (Delete/Move to a sheet/Copy to a sheet)
Press CTRL+SHIFT+D to start the process
It is ...
details
|
|
Views: 563
|
|
Downloads: 76
|
|
UI: En
|
|
Since: 6/18/2009
|
|
|
Delete rows that have Delete string in column A
This is a simple macro that enables you (Once you enable macros) to delete any row that has the value "Delete" in its column A cell, and ignore any other rows.
Press CTRL+SHIFT+D to start the ...
details
|
|
Views: 263
|
|
Downloads: 50
|
|
UI: En
|
|
Since: 6/17/2009
|
|
|
Multiple-Dual-Validations
Here is the project for the lesson in the same name Open Lesson.
It is to demonstrate how to do multiple validations in the same sheet, or as we want to ...
details
|
|
Views: 580
|
|
Downloads: 63
|
|
UI: En
|
|
Since: 5/14/2009
|
|
|
Clear list while typing
Clearing list of duplicates and empty cells list (while you are typing) into a non duplicates, non empty list in the same or another sheet
This will help you enhancing your list ...
details
|
|
Views: 277
|
|
Downloads: 56
|
|
UI: En
|
|
Since: 5/2/2009
|
|
|
Full Row Select
Enables user to select the full row when he/she clicks a single cell
Press CTRL+W to enable this feature (turn it on)
Press CTRL+E to turn it off
You need to copy the code in the ...
details
|
|
Views: 273
|
|
Downloads: 65
|
|
UI: En
|
|
Since: 4/25/2009
|
|
|
AutoDate
Inserts date automatically without using "=Today()" function
It helps to insert the current date and time (NOW) without updating, so the date will be constant and not change with file open or ...
details
|
|
Views: 286
|
|
Downloads: 65
|
|
UI: En
|
|
Since: 4/25/2009
|
|
|
Convert Two-columns-table to Column-Row-table
This Excel file will convert a table of two columns into a Column-Row table
Using functions only and auto-updated once the Main table update
I needed this one few days ago and yYou will ...
details
|
|
Views: 270
|
|
Downloads: 39
|
|
UI: En
|
|
Since: 4/15/2009
|
|
, 
