Sheet protection

[Tanza]

Hi,
I prepared an excel with several formula, i delete/hide the unnecessary cells, formula bar. I applied protection. but some formula are not working when i open that sheet in system with excel 2003. sometimes prompt message like enable macros... etc. is there anyway i can protect the sheet so that will not get any error message/compatibility issue.

Kind regards,
Tanza

[martindwilson]

make sure you save as xls not xlsm or xlsx and don't use any functions that aren't backwards compatible
like sumifs

[royUK]

Formulas that may not work are the new ones like SUMIFS. If you have a macro warning you are possible using User Defined Functions or have code modules in the workbook, they may not even contain code but will trigger the message

[Tanza]

Thanks for your reply
Sorry for late response
I used VLOOKUP function in my excel sheet.
When I tried to open it in another system installed 2003 MS office, it was not working.
Then I changed seting in addins in excel 2003 to enable VLOOKUP formula. Now I want to make this excel in a way if I open it in other system it will not generate any message.
Thank you
Tanza

[Tanza]

I got two code to prevent any message

Application.DisplayAlerts = False
ActiveWorkbook.Close False

If you think it will work, let me know how to execute this code.
Many many thanks in advance
Tanza

[royUK]

VLOOKUP does not need any addin & will work in all versions of Excel