VBA Runtime Error...but I can't click on debug
I get a runtime error but I cannot click on debug. What do I do to debug this error?
"run time error 91 object variable or with block not set"
The VBAProject within the worksheet is more than likely locked. You need to unlock it. Do this by:
- Opening up the Microsoft VBA Window ALT + F11
- Right-clicking your VBA project
- Selecting the VBAProject properties option
- Clicking on the Protection tab and unselecting the Lock checkbox