Compatibility

..... I'm making an awesome file with some macro's, thus saved as an xlsm file.

xlsm file will not work in Excel 2003.

Excel does not gives absolutely security for advanced users.

Depant of the acces that you want to give to the other users you could use 3 different passwords when your workbook is opened by someone.

For this you have to start a new thread.

..will just saving the xlsm file to xls (97-2003) help?

95% yes.

............

You cannot set or manage the macro security level on someone else's computer, they have to do it. Normally, you/they would set it so that the user has to enable or "authorise" the macro(s) to run.

If you are using a much older version of Excel, you may find that it cannot cope with the design, features and the VBA code that has been used.

For example, from Excel 2007, there are many additional functions, such as COUNTIFS and SUMIFS. And things like Conditional Formatting are much more sophisticated. Not to mention something as "simple" as the increased level of nesting in an IF formula.

So, it very much depends on what you mean by "awesome" but I suspect you may have issues.

Regards, TMS

Last question for now... The formulas that do not work (like you said sumifs, countifs, etc.). Will I be able to detect it myself if I save it as a 97-2003 file?

Formulas like these will gives you an error. So you'll be able to detect them. SUMPRODUCT is the formula that you'll need to use for replace theese formulas(Works in ALL Excel editions).

Note: My previous reply "95% YES" was for the qustion "if macros should work in a 2003 file"

The functions, I think will appear to evaluate OK until you try to recalculate. Then you'll get a #NAME? error. The functions will be shown as xlfn.SUMIFS.

As Fotis said, the answer is SUMPRODUCT and, I have to be honest, I find that more flexible than COUNTIFS and SUMIFS.

Regards, TMS



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Thanks for the rep

I kinda have done these things before

I generally offer just a gentle reminder, it doesn't always happen. And it is useful for others to see that you have a solution with which you are happy.

I might sometimes forget to thank people, that does not mean I didn't appreciate the help

If you don't say it, we don't know it.

Just as a reminder: if people don't get thanked for the help they have provided, they might think twice next time you ask. Your choice.