Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for Cell locked please help
Hi
I don't seem to get any error when opening the workbook however it doesnt do the job. I want to allow certain users to be able to amend the content in the Worksheet but if they are not the selected users then they can only view the data. Could anyone please advice me what I have to do. Thank you very much in advance. below is my code Peddie Private Sub Workbook_Open() Dim username As String username = OSUserName() 'If username = "John Smith" Then lock_cells 'Else 'Selection.Locked = True End Sub Sub lock_cells() Sheets("Apr 2006 - Mar 2007").Select Cells.Locked = True End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for Cell locked please help
Sure, you're just missing one more step. In order to block the cells
from being changed, you not only have to lock the cells, but you have to Protect the sheet. Try adding this in: ActiveSheet.Protect Password:="yourpassword" And to reverse it: ActiveSheet.Unprotect Password:="yourpassword" peddie wrote: Hi I don't seem to get any error when opening the workbook however it doesnt do the job. I want to allow certain users to be able to amend the content in the Worksheet but if they are not the selected users then they can only view the data. Could anyone please advice me what I have to do. Thank you very much in advance. below is my code Peddie Private Sub Workbook_Open() Dim username As String username = OSUserName() 'If username = "John Smith" Then lock_cells 'Else 'Selection.Locked = True End Sub Sub lock_cells() Sheets("Apr 2006 - Mar 2007").Select Cells.Locked = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
locked cell not locked | Excel Discussion (Misc queries) | |||
Cell shading locked? | Excel Discussion (Misc queries) | |||
Formula in Cell changes even if it's locked | Excel Discussion (Misc queries) | |||
Put comments on a locked spreadsheet even though cells not locked | Excel Worksheet Functions |