T
tpapaj
Please how to write macro, which fill cell A1 with text "Hello" whe
open the xsl file
open the xsl file
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Ogilvy
use the workbook_Open event. See Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm
Private Sub Workbook_Open()
with Worksheets("Sheet1")
.Range("A1").Value = "Hello"
End With
End Sub
Place this in the thisworkbook module.
http://www.cpearson.com/excel/events.htm
Private Sub Workbook_Open()
with Worksheets("Sheet1")
.Range("A1").Value = "Hello"
End With
End Sub
Place this in the thisworkbook module.
T
tpapaj
i'm sorry, but your sample doesnt wor
J
JMay
Do you have a Sheet1 in the workbook you are opening?
If not change Tom's code reference to Sheet1 to YourSheetName.
If not change Tom's code reference to Sheet1 to YourSheetName.
F
Frank Kabel
Hi
what error did you get or does nothing happen?.
Check if you have places Tom's code into the workbook module (and not
into a standard module)
what error did you get or does nothing happen?.
Check if you have places Tom's code into the workbook module (and not
into a standard module)
T
tpapaj
i'm sorry, it works i didn't paste code into "this sheet