Microsoft Excel
in IT Support ·
Hi there.
I’ve built a Microsoft Excel workbook intended for distribution. The idea is that anyone who downloads it will make their own copy of the blank template to use as a working file.
The issue is protecting the formula cells. I need them to remain untouched, but since the new user won't know which specific cells are off-limits, they end up breaking the calculations.
I am aware of how to protect certain sheets and ranges, but once someone makes a copy of the file, all those protection settings vanish.
I’ve spent some time looking into using scripts to automate a fix, but I haven't had much luck getting them to work.
Is there anyone here who is an expert with Microsoft Excel and scripting?
I’ve built a Microsoft Excel workbook intended for distribution. The idea is that anyone who downloads it will make their own copy of the blank template to use as a working file.
The issue is protecting the formula cells. I need them to remain untouched, but since the new user won't know which specific cells are off-limits, they end up breaking the calculations.
I am aware of how to protect certain sheets and ranges, but once someone makes a copy of the file, all those protection settings vanish.
I’ve spent some time looking into using scripts to automate a fix, but I haven't had much luck getting them to work.
Is there anyone here who is an expert with Microsoft Excel and scripting?