Hi,

I have two pivot tables in the workbook and a macro button to refresh the
tables. We've uploaded the template on the web browser for users. My
problem is when some of the users submitted the completed workbook to us,
the pivot tables was copied and pasted over. The workbook was password
protected and I seriously doubt that the users know how to copy and paste an
existing pivot table.

Have anyone came across this problem? If so, is there a reason why this
keeps on occurring and what is the solution?

Thanks in advance for your help!