Hi
Is there any way to protect worksheet in excel 2007 without affecting the functioning of VBA?
Hi
Is there any way to protect worksheet in excel 2007 without affecting the functioning of VBA?
Protect the sheet via code by enabling the UserInterfaceOnly:= True
But this setting will get lost when the workbook is restarted. So add the code in the Workbook Open event also.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks