Nsryjdtyk

0 Greets! So, I made some charts as templates, and they have to be always the same, but also be able to function when some other users wanna use it (to open). My question is, how to fix this macro that I made so that anyone else can use the same templates but without Manually changing path/location of charts, is it a way to that MAcro "detects" the folder where the charts are?? Until now I have to change PAth everytime if someone else wanna use templates, but I dont wanna that, its a quite waste of time and also Security issue. Hopefully you got my question! Sub Schaltfläche3_Klicken() Dim fd As FileDialog Dim FileChosen As Integer Dim FileName As String Dim tempWB As Workbook Dim i As Integer Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Set fd = Appli...