Hello everyone. I have a excel file that can be downloaded from my site. The
sheet contains a macro that runs onload and a button that calls the same
macro (if the user wants to run it again) they all run fine as long as the
user actually saves the file to his comp. If the user just says to open the
file the onload macro runs fine once, but when the button that runs the same
macro again is clicked the user recieves a file in use error, if they select
to run the read only version the macro cannot be found and then the vb stops
and you receive a error to debug or end. Is there anyway to stops this. I
really, really need some help to figure this one out as soons as possible.
Thanks in advance.