XLSM excel - must resave when edited?

[Laura9876]

Help.

I'm creating spreadsheets for users to use (over 200 people - 16 spreadsheets). I put macros in them to limit the areas they can edit, no format changing and the rest is password protected. My Macro allows them to use the Group/Ungroup and Filter features while still being password protected. So the spreadsheets are saved as XLSM.

However when I go in to test it, I'm noticing it's opening the spreadsheet and renaming it "Tracker 1". I don't want a new name. I want them to edit the ones I created. I created a summary spreadsheet pulling the data from these XLSM spreadsheets and if their renamed.... it won't pull the correct results.

Plus, the users are not excel savvy. If it prompts them to rename it, they'll just shrug their shoulders and rename it without realizing it will mess up the formulas on all my other spreadsheets.

I've spent Hours/Days/Weeks on this. I'm kind of in a panic that I might have wasted my time on this.

Thanks in Advance
Laura

 

[Laura9876]

I'm searching many sites/threads on this. I'm a newbie Macro person. I found this... but not sure if it's for me? Would I put this at the end of my other marcro? My macro is hidden. The users don't know there are macros. Macros make my head hurt.


Private Sub CommandButton1_Click()

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs Filename:= _
"T:\Affiliates\Chicago\One Bank Evolution\Northern Market\2015 Northern MAB Tracker\2015 Far North MAB Tracker.xltm"

Application.DisplayAlerts = True


End Sub

 

[Laura9876]

OMG I found it!

I'm sure it's user error. Somehow I switched from XLSM to XLTM (template) which would then create a new version everytime it's opened. UGH

And this also explains why my summary spreadsheet had major issues with the formuals and kept showing "tracker 1" when I thought I was going into the original.

I have tested my spreadsheets / summary and so far... all looks good.

Whew. I'm helping out another department and didn't want to think I spent all this wasted time on it trying to make it "moron proof" and in the end... I'm the moron!!

I can add this to my list of things I learned.