Protecting a cell

Amortcal

New Member
Joined
May 5, 2002
Messages
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
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,530
Messages
6,114,162
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top