Saving Changes To An Excel Worksheet Automatically

[Jenn78]

i need to set my excel sheets up to beable to replace itsself without a box
prompting me can someone plzzzzzzzzz help?
for example my sheet is a game sheet.when I play my first game I hit a
certain button and it creates a certain folder on my hard drive this folder
is for certain excel sheets but when i go to do another round on the same
excel sheet its suppose to auto replace the first round in that folder.but
instead when I hit the button a box pops up asking if i wanna replace the
first one.

 

[shajueasow]

Welcome to the board.
Can you post the code plz.
Or try in your code the following line in the just before you give in the value:
Application.DisplayAlerts=False
But this will prevent the display of alerts of any kind. So use it carefully.
If not, posting your code might help in getting exactly what you want.

 

[Jenn78]

I didn't create these sheets tho they are designed to automatically do this or is there a place in my software to put this in?

 

[shajueasow]

Cannot say more without knowing on what your game is how it is coded and so on.

 

[Smitty]

Welcome to the Board!

In your save code you can use:

Application.DisplayAlerts = False
  ActiveWorkbook.Save 
Application.DisplayAlerts = True

HTH,

Smitty

 

[Jenn78]

I tryed this and it says it can't find something.I went to "TOOLS" "OPTIONS" then the "SAVE" tab is this right?
I'm very lost with this problem.Could it be a setting in my folder options somewhere maybe?I have windows xp

 

[Smitty]

I tryed this and it says it can't find something.I went to "TOOLS" "OPTIONS" then the "SAVE" tab is this right?
I'm very lost with this problem.Could it be a setting in my folder options somewhere maybe?I have windows xp

Sorry, what I posted is VBA code. You won't find it in Tools-->Options. I assumed from what you were saying that you had some code in your project?

Regardless, without VBA, you won't be able to get rid of the Save As Overwrite prompt.

Smitty

(Note that I'm outta here for a flight north and won't be able to check in until tomorrow evening at the earliest, so if I don't respond it's not because I'm being rude. )

 

[Jenn78]

Thanks for the advice
I did not create this sheet ththers use these sheets as well on their own
computers and never gets this prompt.Thats why I am stumped at why I get it.

 

[shajueasow]

Might be because i their computers the Macro Security (Tools>Macro>Security) is set to LOW.
My opinion is that it is not a safe thing to keep your security level to LOW. It allows any code to be run without your permission.

 

[Jenn78]

Yes we are all on Low under Macro Security