In the attached s-sheet there is green ActiveX button on the MasterCopy sheet tab that is acting weird. When I select a destination folder it stays and uses the folder assignment over and over. However when someone else uses the file the value needs to be reset each time the "Create .SIF from selected group of cells" button is used.
Select a destination folder first by clicking the green ActiveX button, then by selecting 3 or more cells in column C, then clicking Create .SIF from selected group of cells" button, the green ActiveX button goes back the "Browse" and needs to be reset again each time.
It is not doing this for me. Why is the folder save destination not being saved so it can be used again? Why does it work for me and not have other users of the file. What changes do I need to make to allow other users to use the file as I do?
Please advise and thanks.