The authorize person only allowed to view authorize data in master report by using password provided.
On monthly basis, we have to send a lot of monthly report to our clients. From master monthly report, we have to manual separate the master report to sub report and send to other batch of clients.
Master report and sub report is same layout. The different is recipient due to confidential data.
Our new proposal is tend to send the master report for all recipients. Our ideal master report is contains with macro, password and other formula. The authorize person only allowed to view authorize data in master report by using password provided.
Example –
Please refer to file attached. Kindly advice what kind of setting should we set.
Thanks
Attachment | Size |
---|---|
Example File.xls | 24.5 KB |
- shermaine2010's blog
- Login or register to post comments
- 5023 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago