troubleshooting Question

how can i restrict modification/change of certain ranges in a worksheet with VBA

Avatar of Flora Edwards
Flora EdwardsFlag for Sweden asked on
VBA
2 Comments1 Solution62 ViewsLast Modified:
I need help with a code.  

basically,

the code should not allow user to modify any values into the followings ranges of Sheet("Data")

the only modification should be allowed by the Sub procedure that writes values into these cells that procedure name is Macro500

i googled to find the worksheet change event that restricts but i could not find something useful.

A33:B34
A38:B39
A15:B16
A21:B28
D15:K17
C21:K30
D32:K35
C38:K40
B6:C9
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros