I have 1 template that I don't want a variety of users to save on top of. I want people to be able to use it to generate reports but keep it blank, saving their own results in a separate document.
Therefore, I forced "Read Only" when people open the spreadsheet using this VB code:
I'm running into 2 issues:
1. After someone hits "Save As" and it becomes another document, later on that new document also becomes Read Only and I don't want this. Is there some way to reference the specific name of the original report template document so that it's only read only if the file name is that original document name?
2. Users are supposed to copy/paste information from another workbook. Whenever I toggle across workbooks in the same instance of Excel, selecting my Read Only reports template workbook, I get "Run-time error '1004': Method 'ChangeFileAccess' of object '_Workbook' failed".
Any thoughts? Thanks so much in advance!