Now() causes my dates to refresh automatically at inopportune times

[BajanPOET]

Whenever the external queries in my Excel document refresh, the date (which I have displayed using Now() changes from whatever it was to the current date. How do I get this to stop happening? Is there a way that I can automatically generate the date when the file opens but then stop it from changing once the Excel spreadsheet is saved?

What? Who? ME????

 

[SkipVought]

Hi,

In the Workbook_Open event

Worksheets([b]yoursheetname[/b].[A1].value = Date

Skip,

_[red][/red]

 

[BajanPOET]

Silly question - how do I get to the Workbook_Open event again?

What? Who? ME????

 

[SkipVought]

in the VB editor, ctl+R opens the Project Explorer.

Select the ThisWorkbook Object

Skip,

_[red][/red]

 

[BajanPOET]

ok

What? Who? ME????

 

[BajanPOET]

Another thing... In the above code, you've opened up brackets but never close them! Where are they supposed to close?

This is what u have

Worksheets(yoursheetname.[A1].value = Date

Thanks

What? Who? ME????

 

[SkipVought]

Sorry...

Worksheets(yoursheetname).[A1].value = Date

so if your sheet name is Sheet1...

Worksheets("Sheet1").[A1].value = Date

Skip,

_[red][/red]

 

[BajanPOET]

Oh disregard earlier post... I looked at it again and saw where the closed bracket was! lol.

sorry heh heh lol.


What? Who? ME????

 

[BajanPOET]

ok got it


What? Who? ME????