+ Reply to Thread
Results 1 to 13 of 13

How to make a locked cell auto update

Hybrid View

  1. #1
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: How to make a locked cell auto update

    My mistake I put a zero in place of the letter O. Try:
    Sub SaveAsThis()
    
    Const Variable1 As String = "22032011"
    Dim ws As Worksheet
    Dim xshape As Shape
    Dim c As Range
    
    Application.Dialogs(xlDialogSaveAs).Show "Report" & Variable1 & ".xls"
    Range("O2").Locked = False
    Range("O2").Value = Range("O2").Value + 1
    Range("O2").Locked = True
    For Each ws In ThisWorkbook.Worksheets
        For Each xshape In ws.Shapes
            If xshape.Type = msoFormControl Then
                xshape.ControlFormat.Value = False
            End If
        Next
    Next
    For Each c In Sheets("FrameChecklist").UsedRange
        If c.Locked = False Then
            c.Value = ""
        End If
    Next
    End Sub
    On your second question, it might look something like this:
    Range("A48,A49,C18,C25,C37,C45,C47").ClearContents
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."

  2. #2
    Registered User
    Join Date
    02-18-2014
    Location
    Gold Coast, Australia
    MS-Off Ver
    Office 365
    Posts
    8

    Re: How to make a locked cell auto update

    Hi again

    where in the code would you recommend that i paste the .ClearContents

    mclark15

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Locked some cell and make if function
    By okyjelly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-20-2013, 09:57 PM
  2. Replies: 1
    Last Post: 01-09-2011, 11:08 PM
  3. Locked choices in dropdown cell and auto go to...
    By Getalinks in forum Excel General
    Replies: 14
    Last Post: 03-25-2010, 06:55 PM
  4. Make a cell grey and locked
    By SFFliberte in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-15-2009, 09:30 PM
  5. Pivot talbe, how to make it to auto update
    By feejo in forum Excel General
    Replies: 1
    Last Post: 06-02-2007, 12:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1