Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initial Value=""
I think that what I want is advice on how to set the value of a certain cell
to "" when a file is opened. Here is what I am trying to do ...' I have a complicated sub running from a command button. As it is processing I display a message "Processing 1", "Processing 2", "Processing 3" etc until finally "Processing Complete". But when the file is saved and reopened the "Processing Complete" message is still displayed. My thought is to blank the cell upon opening of the file. Your thoughts? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initial Value=""
Use the Workbook Open event
Private Sub Workbook_Open() Sheets("Shee1").Range("A1") = "" End Sub Isnt it a better way to display the status in the status bar itself Application.StatusBar ="<Status" -- If this post helps click Yes --------------- Jacob Skaria "Bigfoot17" wrote: I think that what I want is advice on how to set the value of a certain cell to "" when a file is opened. Here is what I am trying to do ...' I have a complicated sub running from a command button. As it is processing I display a message "Processing 1", "Processing 2", "Processing 3" etc until finally "Processing Complete". But when the file is saved and reopened the "Processing Complete" message is still displayed. My thought is to blank the cell upon opening of the file. Your thoughts? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initial Value=""
Two great assists. Thank you. Certainly the better way is to use the status
bar, which is what I will do, but know I also can explore Workbook_Open as well for other programs. "Jacob Skaria" wrote: Use the Workbook Open event Private Sub Workbook_Open() Sheets("Shee1").Range("A1") = "" End Sub Isnt it a better way to display the status in the status bar itself Application.StatusBar ="<Status" -- If this post helps click Yes --------------- Jacob Skaria "Bigfoot17" wrote: I think that what I want is advice on how to set the value of a certain cell to "" when a file is opened. Here is what I am trying to do ...' I have a complicated sub running from a command button. As it is processing I display a message "Processing 1", "Processing 2", "Processing 3" etc until finally "Processing Complete". But when the file is saved and reopened the "Processing Complete" message is still displayed. My thought is to blank the cell upon opening of the file. Your thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why does the initial zero in "01625" in a number cell disappear? | Excel Discussion (Misc queries) | |||
Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows. | Excel Programming | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |