I have a sales forecasting spreadsheet that has been distrubited to our sales
force. An error was found in one cell that requires a fix, but, the workbook
is passworded, the page the error is in is protected with password and the
column the cell is in is hidden. I was wondering if it is possible to create
a patch to correct this simple error via vb or vba. To call all of these
sheets back would be too time consuming and to allow the sales people access
to passwording and page protection would be too dangerious.
Any thoughs on this
Thanks