Hi
this is a tough one
hard to explain and the file contains alot of code can be confusing
the code all works fine manually (using F8) and automatically using a button
i am trying to unprotect the sheet("RawData") to transfer data in the sheet then protect it at the end of the code to prevent any changes
it seems to work the first time after opening the file but then it doesnt work after that
if anyone would like to work through the process please do so as follows
Form opens on opening
Select BS969
Select Go & No Go
Enter Go = 10
Enter No Go = 11
Select THV - FC132
Select Metric
the first time Sheet("RawData") will be protected but if you try it again pressing the button 'Open Form' the sheet is not protected
why? i have no idea
would appreciate any comments and suggestions on how to improve my code
thanks in advance
Bookmarks