I have a XLSM (macro enabled excel) file stored in a document library. This file is a template we use for some signoffs.
I have granted users view only access to this file, as I do not want anyone filling in the template and saving this back to the document library. The issue comes about when users download the file, they get an error saying they have to open the file in read
This is fine, but when users save the file, many save it as a regular XLS file, where the macro has been stripped out and no longer works.
Can I fix this with entitlements and still preserve my master template, or is this an issue that is solved on the xls side?
According to your description, your macro not work when save XLSM file as XLS file. So, this is may be your VBA code was affected. I think you’d better to ask the question on EXCEL forum, May be get more help. Here is the link about some reasons for why
some VBA codes not work .
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.