Beatrix
05-22-2017, 09:14 AM
Hi Everyone
I have got a spreadsheet with a vba script which runs data and protects the control worksheet with a password at the end.However a certain cell with a specific formula in H2 displays error #VALUE!. When I unprotected the worksheet and double clicked on column H to resize then it shows the value.
I added a line to script to change the width or auto fit or update the formula or
Application.Calculation = xlCalculationAutomatic however nothing changed.
Any suggestions to fix this problem would be much appreciated.
Many Thanks
B.
I have got a spreadsheet with a vba script which runs data and protects the control worksheet with a password at the end.However a certain cell with a specific formula in H2 displays error #VALUE!. When I unprotected the worksheet and double clicked on column H to resize then it shows the value.
I added a line to script to change the width or auto fit or update the formula or
Application.Calculation = xlCalculationAutomatic however nothing changed.
Any suggestions to fix this problem would be much appreciated.
Many Thanks
B.