dosn`t save properly

[Eddy S]

[SOLVED]Hello everyone! Could you help me with my excel file? looks everything is working,calculating and saving the history,but when i`m presing save my list is calculating the names again and dosn`t save the previous list in job history. could you help me to prevent this problem? calculation options-manual,whet it`s on automaticly works fine,but happening the same problem when i`m changing some data in it. Thanks for your help!

[FDibbins]

hi and welcome to the forum

just for future reference, please give your thread a name that is more descriptive of what you are trying to do. The 1 you are using here just barely makes it....look at it this way, if you typed that into google, what you would expect to get back?

Looking at your file, everything is being driven from the RAND() function on sheet2. when you use a RAND() function, it will change EVERY time you do anything in the file - like entering data, deleting,pasting, undoing, and when you open the file, it will calc again

[Eddy S]

thanks for answer! so, what i should do now?

[xladept]

Hi Eddy S,

Maybe the Workbook_BeforeSave:

Please Login or Register  to view this content.

[Eddy S]

hi xladet.
thanks for answer
i`m not so close with macros. i made all this from reading books a lot and small help from side.it took me to make this about month :D so what should i do with this code?

[xladept]

Hi Eddy S,

I'm sorry that I omitted these instructions:

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Open your Workbook

Save your Workbook or Another Workbook designated for Macros as Macro_Enabled

Press ALT + F11 to open the Visual Basic Editor.

Select "ThisWorkbook" from the Insert menu

Type "Option Explicit" then paste the code under it and you're up and running

[Eddy S]

thank you very much! it is working you are the best!

[xladept]

You're welcome!