worksheets with VBA - protection

[Robert_G]

Can worksheets be protected to view only that have VBA code assigned to them that are linked to other worksheets?

I have one work sheet that is for data entry and another work sheet link that I want to be viewed only. The view only worksheet has cell's linked to the first with charts, conditional formatting and VBA assigned in specific parts.

 

[Kamolga]

After you have protected and unprotected the cells properly as you do for manually protecting the sheets, you can use the code below to protect it from users but not from macro (the macros will run as if it was not protected).

[LEFT][COLOR=#222222][FONT=monospace]
[/FONT][/COLOR]        Activesheet.Protect Password:=[FONT=monospace]"abc"[/FONT], UserInterfaceOnly:=[FONT=monospace]True[/FONT][COLOR=#222222][FONT=monospace]
[/FONT][/COLOR][/LEFT]

It is much easier to automatically protect all the sheets when opening the file, so you can unprotect them to work on the file and forget about protecting them when you are done..

In VBA, you have the sheets in left column. 2x click on "This Workbook" and paste this code to do so.

[LEFT][FONT=Courier New][LEFT][FONT=Courier New][LEFT][FONT=monospace]Private[/FONT] [FONT=monospace]Sub[/FONT] Workbook_Open()
    [FONT=monospace]Dim[/FONT] wks [FONT=monospace]As[/FONT] Worksheet
    [FONT=monospace]For[/FONT] [FONT=monospace]Each[/FONT] wks [FONT=monospace]In[/FONT] ThisWorkbook.Worksheets
        wks.Protect Password:=[FONT=monospace]"abc"[/FONT], UserInterfaceOnly:=[FONT=monospace]True[/FONT]
    [FONT=monospace]Next[/FONT] wks
[FONT=monospace]End[/FONT] [FONT=monospace]Sub[/FONT][/LEFT]
[/FONT][/LEFT]
[/FONT][COLOR=#ffffff][FONT=Courier New]
[/FONT][/COLOR][/LEFT]