Link to home
Start Free TrialLog in
Avatar of tampabay420
tampabay420

asked on

Excel Protected Cells and VBA Macros

Hey, i'm locking cells in order to keep users from modifying them, but i also need to give acceess to the Macro/VBA...

example: i want to put a value in a cell, but not allow user's to change the cells contents...?
thanx in advance :D
ASKER CERTIFIED SOLUTION
Avatar of Brian Mulder
Brian Mulder
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tampabay420
tampabay420

ASKER

hey, good thinking... i'll just unprotect the sheet for a sec while'st i do the calc- thanx for the idea :-)
:) cool and thanks for the grade