|
|
#12
08-16-2011, 04:35 AM
|
|||
|
|||
replace sub auto open with this:
Sub auto_open() Dim WS_Count As Integer Dim i As Integer WS_Count = ActiveWorkbook.Worksheets.Count For i = 1 To WS_Count ThisWorkbook.Worksheets(i).OnEntry = "CopyFormulaResults" Next End Sub 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Merge Fields and Static Text | kbranden | Mail Merge | 1 | 06-15-2011 09:02 AM |
 Making items (text, pictures, etc.) static on page
|
Jeremiahts | Word | 3 | 04-07-2011 09:54 PM |
| convert html to text at opening | etfjr | Word | 0 | 12-13-2010 11:14 AM |
| Convert Number to Text | devcon | Word | 0 | 07-10-2010 01:16 AM |
|
Checkbox on Userform result in Text in Word
|
Dolfie_twee | Word VBA | 1 | 06-22-2010 07:54 AM |
Windows Vista 
Office 2007
Threaded Mode