Search results for query: *

It worked in both the workbook_activate and workbook_open events. I'll keep the multiple worksheet comment in mind when I have that situation. Thanks for your help.

I believe it's in the worksheet module. I right click on Sheet1(Sheet1) and select View Code.

I'm trying to force a default value of 0.25 in cell D21 whenever someone opens Sheet1 in an Excel 97 workbook. I tried to use the worksheet activate event: Private Sub Worksheet_Activate() Worksheets("Sheet1").Range("D21").Value = 0.25 End Sub copying this code from...

That's what I really love about MS Word, it's so intuitive. Who'd a' thunk you needed to use a picture in the merge field and that Alt+F9 gives access to the merge field code. Just so obvious! The switch picture example in the lead paragraph to the "Numeric Picture (\#) field...

I have an Access 97 table as a data source for a Word 97 merge document, which is designed as a form using a table. I am merging both text and currency data into the table's cells. Currency is coming across as a number, dropping trailing zeros and decimals (i.e. $12.10 and $13.00 in Access...

I created a table and want any text I type into one particular cell to be bolded and I want the font to be larger that other cells. I can bold the text I'm currently typing, but if the cell is originally empty and I tab into it, the insertion point is placed after the turn off bolding command...