Protecting a cell

Amortcal · May 6th, 2002, 07:43 PM

I prepared an amortization spreadsheet using Input Boxes and a number of macros. My problem is that I want to force users to use the Input Boxes and NOT to enter the data directly in the cells.

I thought I could do this by protecting the cells, but each time I protect the cells, the macros fail!

How can I get the macros to work while the cells are protected? Really appreciate your help...

[ This Message was edited by: Amortcal on 2002-05-06 18:45 ]

Qroozn · May 6th, 2002, 07:46 PM

i use the following code in worksheets that i dont want the user to clcik on the protected boxes(where they'd normally get a message saying they are restricted).
it means that only those cells that are unprotected can be clicked on

With Worksheets("index")
.EnableSelection = xlUnlockedCells
.Protect DrawingObjects:=True, contents:=True, userInterfaceOnly:=True
End With

Amortcal · May 6th, 2002, 07:54 PM

Thanks Qroozn....but can you give me some more details. How do I specify within the code that you sent, the actual cells that I want to be protected? Thanks again.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 6th, 2002, 07:43 PM	#1
Amortcal New Member Join Date: May 2002 Posts: 10	I prepared an amortization spreadsheet using Input Boxes and a number of macros. My problem is that I want to force users to use the Input Boxes and NOT to enter the data directly in the cells. I thought I could do this by protecting the cells, but each time I protect the cells, the macros fail! How can I get the macros to work while the cells are protected? Really appreciate your help... [ This Message was edited by: Amortcal on 2002-05-06 18:45 ]

May 6th, 2002, 07:46 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	i use the following code in worksheets that i dont want the user to clcik on the protected boxes(where they'd normally get a message saying they are restricted). it means that only those cells that are unprotected can be clicked on With Worksheets("index") .EnableSelection = xlUnlockedCells .Protect DrawingObjects:=True, contents:=True, userInterfaceOnly:=True End With

May 6th, 2002, 07:54 PM	#3
Amortcal New Member Join Date: May 2002 Posts: 10	Thanks Qroozn....but can you give me some more details. How do I specify within the code that you sent, the actual cells that I want to be protected? Thanks again.