How can I protect my excel so that no one can edit it, but some macros can function over this spread sheet?

Question

I want to make my spread sheet protected like that it would be protected to edit manually, but macros can function over this spread sheet. For example: there is a sheet and I want to enter present time in a particular cell. Time can enter only through a macro (e.g. ctrl + shift + T), no one can enter the time manually.

Anonymous · Accepted Answer

Highlight the cells you want to protect,right click,click format cells goto protection"lock them"

Unlock the cells you want editable

after doing this goto tools @ main menu, click protection and select unlocked cells only,unclick all others

I don't place passwords because if you create a lot of workbooks and you use different passwords,gets confusing

? · Answer

Sub HighlightRows() Dim c As Range Dim SrchRng As Range Dim SrchStr As String Dim firstAddress As String Set SrchRng = ActiveSheet.Range("A1", ActiveSheet.Range("A65536").End(xlUp)) SrchStr = InputBox("Please Enter A Search String") Set c = SrchRng.Find(SrchStr, LookIn:=xlValues) firstAddress = c.Address Do If Not c Is Nothing Then c.EntireRow.Interior.Color = RGB(0, 200, 200) Set c = SrchRng.FindNext(c) End If Loop While Not c Is Nothing And c.Address <> firstAddress End Sub

brayden · Answer

What version of Excel? To answer your question, you can protect your sheet and then control exactly what features within that protection you want the users to have access to.

Anonymous · Answer

Give a password and protect it.....

* mèyshì * · Answer

Give it password

c.c

Trending News

How can I protect my excel so that no one can edit it, but some macros can function over this spread sheet?

5 Answers