Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
Please how to write macro, which fill cell A1 with text "Hello" whe
open the xsl file -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
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. -- Regards, Tom Ogilvy "tpapaj " wrote in message ... Please how to write macro, which fill cell A1 with text "Hello" when open the xsl file? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
Do you have a Sheet1 in the workbook you are opening?
If not change Tom's code reference to Sheet1 to YourSheetName. "tpapaj " wrote in message ... i'm sorry, but your sample doesnt work --- Message posted from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
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) -- Regards Frank Kabel Frankfurt, Germany i'm sorry, but your sample doesnt work --- Message posted from http://www.ExcelForum.com/ |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
fill A1 when open xsl file
i'm sorry, it works i didn't paste code into "this sheet
-- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Excel Discussion (Misc queries) | |||
Unable to open a 82 KB XLSM file due to "Too many different cellformats" & "Converter failed to open the file." errors. | Setting up and Configuration of Excel | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) | |||
Open email windows can't open, excel shreadsheet file .xls ? | Excel Discussion (Misc queries) |