Edit/Fill/Series on Protected Sheet

I

iamageneralist

Is there any way to allow the use of the Edit/Fill/Series command for
unlocked cells on a protected sheet?
 
I

iamageneralist

I found the macro copied below for filling numbers to the end of data and
then modified it for my start point and columns and then added lines for
unprotect and protect and then added it as a macro button on the protected
sheet.


Re: Number Cells Until End Of Data Macro

--------------------------------------------------------------------------------

Untested...


VB: AutoLinked keywords will cause extra spaces before keywords. Extra
spacing is NOT transferred when copy/pasting, but IS if the keyword uses
"quotes".
Sub Add_Numbers()
Dim r As Range, c As Range
Set r = Range("A2:A" & Range("B65536").End(xlUp).Row)
For Each c In r
c.Value = c.Row - 2
Next c
Set r = Nothing: Set c = Nothing
End Sub
 

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

Series fill only copying and fill series greyed out 1
fill series and protection 1
Fill series not working as expected 1
Series button 1
fill series option not available 5
Protected Worksheet Tab Order 1
How to prevent Cut&Paste to change style and data validation on protected sheet 1
In Excel I need to insert a clean form each use 1

Top