Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Albert Smith   on Oct 29 In MS Office Category.

  
Question Answered By: Christie Bradley   on Oct 29

I actually accomplished what I wanted with the following:

ActiveSheet.Protect UserInterfaceOnly:=True

I don't think there is an issue about locked versus unlocked, because
it works fine now. Before, I had protected two sheets  manually (not
the whole workbook) with no password and the protection worked; then
I had attempted to unprotect  them at the beginning of my routine and
then protect  them again at the end. I have no clue why what I did
before didn't work.

Share: 

 

This Question has 5 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Protect/Unprotect Or get search suggestion and latest updates.


Tagged: