Hi all,
I am new to this forum and a novice with excel vba/macro. With the help of this forum and other websites I have managed to develop a code to automate some simple tasks.
To be specific I have 3 worksheets. One input worksheet, one output sheet and one sheet where I do all my intermediate calculations. User is required to input in the input sheet and clicking on some buttons (in the input sheet) will perform calculations and report output.
Now I would like the end user to not be able to mess with the calculation worksheet, so I protect the worksheet. After I protect with a password, my code errors out at "Sheets("CALC").Select" where CALC is the name of my worksheet where I do the intermediate calculation. So it appears as if password protecting the sheet prevents the sheet from even being accessed.
The error I get is Run-time error '1004': Select method of Worksheet class failed
Code runs fine if I leave everything unprotected.
Since my file containts some proprietary information I am unable to attach it as is. If however this is a specific problem, I will modify the worksheet and attach it. I thought this is a basic problem and there might be some simple fixes.
Thank you very much,.
newbie !
Bookmarks