How to.......

[Ram]

I want that when i save the the excel, one coloum should
be always blank.

e.g field A1.
i always make changes in the filed A1 marking * and
selecting the same. But when i save i want that A1 coloum
should be blank i.e without any *

whould be grateful if got help

 

[Frank Kabel]

Hi
one way would be using the workbook_Beforeclose event.
Put the following code into your workbook module (not in a standard
module):


Private Sub Workbook_BeforeClose(Cancel As Boolean)
dim wks as worksheet
set wks = me.worksheets("sheet1")
wks.range("A:A").clearcontents

Application.displayalerts = false
me.save
Application.displayalerts = True
end sub