Results 1 to 5 of 5

Can DrawingObjects:=False be applied to a range instead of the entire worksheet?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-29-2010
    Location
    Tallahassee, FL
    MS-Off Ver
    365
    Posts
    100

    Can DrawingObjects:=False be applied to a range instead of the entire worksheet?

    The files in the outlined area need to be protected except when documents need to be added or deleted, so I have a Lock/Unlock button for protecting the cells in that range.

    This code snippet is as close as I have been able to come to allowing .pdf files to be inserted, moved around and deleted from the outlined range (B26:C37) while the sheet is protected. The problem is that there are a couple of show/hide pictures outside of the that range that toggle red (locked) or green (unlocked) based on whether the range is locked from editing or not, and the snippet also unprotects them. I'd like them to stay protected with the rest of the sheet. Is there a way to apply this to just B26:C37?
    ActiveSheet.Protect "", DrawingObjects:=False, Contents:=True, Scenarios:=True
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Specifing entire worksheet as range to export sheet to access
    By UML in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2015, 05:41 PM
  2. [SOLVED] Macro DrawingObjects=false, but cannot insert a picture?
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-16-2014, 12:17 PM
  3. Conditional format using text applied to entire row
    By bopsgtir in forum Excel General
    Replies: 1
    Last Post: 12-02-2010, 12:02 PM
  4. Table Array Entire Worksheet Instead Of Named Range
    By Spencer in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-02-2007, 11:18 PM
  5. Address Entire Worksheet as a range
    By Klatuu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-23-2006, 03:30 PM
  6. ScreenUpdating just a range of cells instead of entire worksheet
    By scottzuehl@gmail.com in forum Excel General
    Replies: 1
    Last Post: 02-18-2006, 07:55 PM
  7. Macro to print a selected range, not entire worksheet
    By James C in forum Excel General
    Replies: 3
    Last Post: 10-19-2005, 05:12 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