Web Development

Ask something
Discussion Locked

PLS HELP ASAP! how to protect sheet

0 helpful
2 replies

by hilalpaksoy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i ve sheets to be protected but there are macros working on that sheets.so when i protect sheet and put a password then macro doesnt work, it stops and ask for the password.it is a data entry system i want people process data and run macro but i dont want them to be able to change the other sheets which macro process the data into. how can i do that???
thanks in advance

2 replies

by bristar

You can write the document protection into your macros. Include the ActiveSheet.Unprotect at the beginning, make your changes, then add an ActiveSheet.Protect at the end.

by the_furry_man

iF you do not need to see the data on the 'protected' sheets, then simply set the visible attribute of the sheet to 'xlSheetVeryHidden' (value 2) via the properties panel in VB macro editor. Then the users will not even know the sheets exist.

This discussion is closed to new replies.