 |
 |
Topic Title |
Topic Starter |
Replies |
Views |
Last Action |
 |
|
Add & Delete Ole Button And VBA Code
Just to show how... |
johnske |
0 |
699 |
March 19, 2006 Last Post by: johnske |
 |
|
Adjust To Users Screen Resolution
Change screen resolution |
johnske |
0 |
728 |
March 19, 2006 Last Post by: johnske |
 |
|
Apply Carriage-return & Line-feed_Worksheet
Automatic return and feed |
johnske |
0 |
314 |
March 19, 2006 Last Post by: johnske |
 |
|
Autobackup Workbook
Template for autobackup workbooks |
johnske |
0 |
300 |
March 20, 2006 Last Post by: johnske |
 |
|
Basic Invoice Book
Ready to use! |
johnske |
0 |
323 |
March 19, 2006 Last Post by: johnske |
 |
|
Browse & Import Code Modules
Import code modules via macro |
johnske |
0 |
331 |
March 20, 2006 Last Post by: johnske |
 |
|
Call IE And Link To Web-site
Using Internet Explorer |
johnske |
0 |
268 |
March 19, 2006 Last Post by: johnske |
 |
|
Change Excel Icon
(Sometimes useful) |
johnske |
0 |
867 |
March 20, 2006 Last Post by: johnske |
 |
|
Check Compatibility Of Office Versions
Check whether code will work |
johnske |
0 |
295 |
March 19, 2006 Last Post by: johnske |
 |
|
Code as you go
Don't have sheet code cluttering sheets |
johnske |
0 |
251 |
March 20, 2006 Last Post by: johnske |
 |
|
Concatenate Function
Concatenate all cells in a range |
johnske |
0 |
693 |
March 20, 2006 Last Post by: johnske |
 |
|
Delete Duplicates in Cells
Remove all duplicated entries |
johnske |
0 |
616 |
March 20, 2006 Last Post by: johnske |
 |
|
Delete Hyperlinks, Links, Formulas From Book
(Says it all) |
johnske |
0 |
241 |
March 20, 2006 Last Post by: johnske |
 |
|
Delete Links To Other Sheets Or Books
(Leave values and code) |
johnske |
0 |
674 |
March 19, 2006 Last Post by: johnske |
 |
|
Delete Links, Formulas (worksheet)
Delete all links |
johnske |
0 |
392 |
March 20, 2006 Last Post by: johnske |
 |
|
Delete Styles From Other Workbooks In Folder
Style multi-delete |
johnske |
0 |
627 |
March 20, 2006 Last Post by: johnske |
 |
|
Diabetics Log
Handy workbook for diabetics |
johnske |
0 |
195 |
March 20, 2006 Last Post by: johnske |
 |
|
Download From HTML Site
Program a download |
johnske |
0 |
281 |
March 19, 2006 Last Post by: johnske |
 |
|
Enter Date In Cell(s) Using MS Month View
Use MS monthview calendar control |
johnske |
1 |
1,252 |
March 30, 2006 Last Post by: johnske |
 |
|
Exit Windows
Logoff, shutdown, reboot, force |
johnske |
0 |
404 |
March 20, 2006 Last Post by: johnske |
 |
|
Extract Data from Closed Book
How to get data when a book is closed |
johnske |
0 |
954 |
March 20, 2006 Last Post by: johnske |
 |
|
Follow Any Path
ActiveWorkbook Path |
johnske |
0 |
571 |
March 19, 2006 Last Post by: johnske |
 |
|
Force Macros
Force users to enable macros |
johnske |
0 |
909 |
March 20, 2006 Last Post by: johnske |
 |
|
Forward & Back function
Bookmark locations to go back to |
johnske |
0 |
268 |
March 20, 2006 Last Post by: johnske |
 |
|
Get Userform Metrics
Use to hard-code all form metrics |
johnske |
0 |
342 |
March 20, 2006 Last Post by: johnske |
 |
|
Hide the Gridlines
Autohide gridlines |
johnske |
0 |
272 |
March 20, 2006 Last Post by: johnske |
 |
|
Hide The Zeroes
Don't show zero values |
johnske |
0 |
244 |
March 20, 2006 Last Post by: johnske |
 |
|
Hide Unused Rows
(Unhide used rows) |
johnske |
0 |
671 |
March 20, 2006 Last Post by: johnske |
 |
|
Import Notepad & Wordpad Text Files
Put text into a spreadsheet |
johnske |
0 |
235 |
March 20, 2006 Last Post by: johnske |
 |
|
Install/uninstall Activex Controls .ocx/.dll
(Includes month view calendar control) |
johnske |
0 |
421 |
March 20, 2006 Last Post by: johnske |
 |
|
List Macros
List all macros in workbook |
johnske |
0 |
376 |
March 20, 2006 Last Post by: johnske |
 |
|
Lock Excel when inactive
Secure your workstation when absent |
johnske |
0 |
234 |
March 20, 2006 Last Post by: johnske |
 |
|
Log Dates/Times a Books's Been Opened
Catch the company spy :) |
johnske |
0 |
334 |
March 20, 2006 Last Post by: johnske |
 |
|
Move Direction After Hitting Enter
Set move direction automatically |
johnske |
0 |
281 |
March 20, 2006 Last Post by: johnske |
 |
|
One Line Find function
Streamline your Find functions |
johnske |
0 |
218 |
March 20, 2006 Last Post by: johnske |
 |
|
Open Any File Or Application.
Open anything with hyperlinks |
johnske |
0 |
652 |
March 19, 2006 Last Post by: johnske |
 |
|
Open At A Given Sheet And Range
Works even if sheet's been renamed |
johnske |
0 |
239 |
March 19, 2006 Last Post by: johnske |
 |
|
Open Web Page & Search
(From excel) |
johnske |
0 |
719 |
March 19, 2006 Last Post by: johnske |
 |
|
Populate Multi-column Combobox
Basic procedure |
johnske |
0 |
1,056 |
March 19, 2006 Last Post by: johnske |
 |
|
Programmatically Add Userform
Add form and code with vba |
johnske |
0 |
917 |
March 19, 2006 Last Post by: johnske |
 |
|
Put Cell in Top-Left (Goto)
The use of Goto |
johnske |
0 |
745 |
March 20, 2006 Last Post by: johnske |
 |
|
Recycle Worksheets
Reclaim sheets with old/wrong entries |
johnske |
0 |
220 |
March 19, 2006 Last Post by: johnske |
 |
|
Restore Default MS Size Of Workbook.
(Title says it) |
johnske |
0 |
227 |
March 20, 2006 Last Post by: johnske |
 |
|
Run Once Then Delete Code Module
Prevent code copying... |
johnske |
0 |
632 |
March 20, 2006 Last Post by: johnske |
 |
|
Run-once Code With Option
Specify if you want something run again |
johnske |
0 |
219 |
March 20, 2006 Last Post by: johnske |
 |
|
Save Copy Of Workbook Minus Some Sheets
(Title says it all) |
johnske |
0 |
322 |
March 20, 2006 Last Post by: johnske |
 |
|
Save Previous Value As Comment
Remember the last value entered... |
johnske |
0 |
332 |
March 20, 2006 Last Post by: johnske |
 |
|
Save Sheets As Books In Folder
Split up a workbook |
johnske |
0 |
729 |
March 20, 2006 Last Post by: johnske |
 |
|
Search All Books In A Folder
Opens & searches all books |
johnske |
0 |
314 |
March 19, 2006 Last Post by: johnske |
 |
|
Search By Regions
Quick-search |
johnske |
0 |
184 |
March 19, 2006 Last Post by: johnske |
 |
|
Set A Trial Period for Use
Stop unpaid use of your project |
johnske |
0 |
301 |
March 20, 2006 Last Post by: johnske |
 |
|
The Find Function Simplified + An Alternative
(Just to get you started) |
johnske |
0 |
277 |
March 19, 2006 Last Post by: johnske |
 |
|
Updating Your Project From Web
Put "check for updates" in your project |
johnske |
0 |
224 |
March 19, 2006 Last Post by: johnske |
 |
|
Use Command Button As Toggle Button
(Titla says it) |
johnske |
0 |
937 |
March 20, 2006 Last Post by: johnske |
 |
|
Use Standard MS Progress Bars
Two types of status bars |
johnske |
0 |
383 |
March 20, 2006 Last Post by: johnske |
 |
|
Used Region Function
Find the used region |
johnske |
0 |
229 |
March 20, 2006 Last Post by: johnske |
 |
|
Userform Start Position
Fine-tune userform start position |
johnske |
0 |
1,110 |
March 20, 2006 Last Post by: johnske |
 |
|
VBA Code Library
Attachment includes 75 code examples |
johnske |
0 |
459 |
March 20, 2006 Last Post by: johnske |
 |
|
Word - Default Page Setup
(No attachment) |
johnske |
0 |
390 |
March 19, 2006 Last Post by: johnske |
 |
|
Working With Multi-selections
Some examples |
johnske |
0 |
249 |
March 20, 2006 Last Post by: johnske |
 |
|
Working With Union And Intersect
Some demos |
johnske |
0 |
229 |
March 20, 2006 Last Post by: johnske |