Options when Protecting Worksheet

  • Thread starter Thread starter Brad E
  • Start date Start date
B

Brad E

When I Protect a worksheet, there are options I can select
or de-select that the user's can access. When I protect
with a macro, how can I keep the user's from selecting
locked cells?

TIA, Brad E.
 
Hi
you can do the same within VBA. Just record a macro while settings
these options manually to see what options you have in VBA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allow Users to Unfreeze Panes in a Protected Workbook/Sheet 2
Lock a control object 2
auto-protect a sheet upon workbook close 4
Copy data using macro (with worksheet protect) 5
Hiding macro-enabled password 2
Select statement or me? 12
Cursor and Sheet Protection may09 2
Lose Cursor After Protecting Sheet 2

Back
Top