I am trying to develop a spreadsheet with some data in it. Once a user enters the data, clicks on Submit Data. The Submit Data activates a macro which password protects the worksheet. I already have a macro doing this but without password. Is there any way I can add password protection in macro?
Hi,
Yes, you simply add
as an argument to the line that protects the sheet- for example
password:="your password"
activesheet.protect password:="your password"
Don
Please remember to mark your thread 'Solved' when appropriate.
you can use Protect method of worksheet object, e.g.
of course you can specify certain allowed and forbidden actions, e.g.ActiveSheet.Protect "yourpassword"
ActiveSheet.Protect "yourpassword", DrawingObjects:=True, Contents:=True, Scenarios:=True, AllowInsertingColumns:=True, AllowInsertingRows:=True
If you are pleased with a member's answer then use the Star icon to rate it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks