clearing cells

How does one clear cells of values only upon closing the workbook; such that, the next person to open the program cannot see the value posted by the last user? I am able to write a Macro that will clear the cells when the Macro is "run"; but, how to make the Macro run upon closing or opening...

My in-expertise at VBA seems to have caught up with me. As I tried to edit this, it seems all I've done is make it do nothing...:eeek: Here's my code: Sub clear() Dim objColorStop As ColorStop Dim mySelect As Range Dim myOthershtRng As Range Set mySelect =...

Hi all, I am new to vba and i have tried to find a code on here for clearing my whole worksheet but i cant seem to find one which does the specifics i want to or does all the bits :) if i missed something id be very grateful for a thread link... Trying to create a new prf for my team, and i...

hi Just wondering is it possible to clear cells multiple columns based on the criteria instead of column by column. For example: What i am trying to do i have a file with 28000 lines and want the macro to clear contents of the cells in columns W,X,Z,&AA that contain #N/A. Can this be done ...

I have the following code that trolls through 3 columns with some blank spaces in them and it gives me a list of values in I2:I5 that I'm looking for but the red highlighted part isn't working: Sub common2() Dim sh As Worksheet, lr As Long, rng As Range, Brng As Range, Crng As Range Set sh =...