macro to run automatically

Originally Posted by vandanavai

Hi,

I don't konw if this is possible. I have on macro which copies formula in Range A1: A10 and paste values in same range ( through paste special - values). Everytime before file is saved and closed, user has to run this macro. But sometinmes user forgets to do so and some problem is to be faced. So I want to run this macro automatically when file is saved and closed

Please help me.

Hi,

Please Login or Register  to view this content.

should work, paste this into the Workbook (Alt & F11 for VB Editor, select Workbook )

Let me know how you go
---


---

Originally Posted by peejay

the code above does the copying, but does not seem to do "the save", the user would still have to confirm the save on exit of the file

Add this line to the end of the code above.

ThisWorkbook.Close savechanges:=True

then they have no option

hth

Hi peejay,


vandanavai "Thanks Bryan for code. I tried it but it didn,t work"


can you explain what 'didn't work' - the code copies the A1:A10 of the sheet that is active at close, it didn't force a save, but peejay's addition will do that.

Did your A1:A10 cells still have formula?

or did your original post mean that you want the close to run your unnamed macro?


---