Using Macro in Excel, Pivot Table Report works well on Protected Sheet. You can get control over Pivot Table Report and customise as per your requirement.
0 Comments
In franchise business often there is need of issuing franchise agreement, MOU, etc. to the marketing team members on a regular basis. This Franchise Agreement /MOU is a valuable document not just of its monetary cost, however it has legal importance too. In general case, the franchise agreements/MOUs issued to the marketing team members will be used for signing by the business prospects, few may be lying in hand as physical stock as unused or invalid etc. If you need to track the movement of above documents in a systematic way and in very effective manner, then this attached macro based excel file,named "Agreement Utilisation.xlsm" may be useful to your organisation. THIS FILE WILL BE RUN ONLY IN EXCEL 2007 or higher version. Please download the file. Click on the file to open, set security level MACRO ENABLE,read the guidelines carefully and do experiment it.
|
|