mysheet columns are locked but i cant used other formulas please how can i used formulas when my Sheet columns are locked
using VBA
Please let me know
mysheet columns are locked but i cant used other formulas please how can i used formulas when my Sheet columns are locked
using VBA
Please let me know
Protect it via code using UserInterFaceOnly:=True so that you can access the cells using VBA (You Can't Access it Manually).
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
i am using but it still having the same issue
Please Login or Register to view this content.
i am using but it still having the same issue
Please Login or Register to view this content.
i am sorry for multiple reply
On workbook close the Userinterfaceonly setting will get lost.
So you have to re protect the workbook every time the workbook closed and opened.
So add the protection code in Workbook Open Event so that it will enables the UserInterfaceonly every time
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks