Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

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
0
tampabay420
Asked:
tampabay420
  • 2
1 Solution
 
bruintjeCommented:
Hello tampabay420,

you could try to unprotect the cells while running the macro something along the lines of

'unprotect sheet first
'do the action
'protect sheet again

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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now