+ Reply to Thread
Results 1 to 2 of 2

Clear contents in Merged and Un-Merged, Unprotected Cells of a Protected Worksheet.

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    Toronto, Canada
    MS-Off Ver
    365
    Posts
    1

    Clear contents in Merged and Un-Merged, Unprotected Cells of a Protected Worksheet.

    Hello

    I'm looking to have a button linked to a macro, which will clear the contents only (not formatting), of merged and not merged cells that are not protected, in a protected worksheet.

    I have searched forums, tried coding myself, and nothing seems to work as intended. I can make it work before protecting the worksheet, but after protecting the worksheet I can't get anything to work as intended. What kind of worked, was very slow (spinning wheel for ~10 seconds or longer).

    Could someone please help? I could post code, but I don't think it will help, and since I'm a beginner, it's likely not streamlined. Any help would be greatly appreciated.

    I can post the file if necessary.

    Thank you

  2. #2
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,340

    Re: Clear contents in Merged and Un-Merged, Unprotected Cells of a Protected Worksheet.

    you could just wrap your working code in the code to unprotect the sheet and re protect it like maybe

    Please Login or Register  to view this content.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

+ 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. [SOLVED] Clear merged and non-merged cells in named range.
    By IMM Tech in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2018, 12:37 PM
  2. Clear merged cell contents in comand button(clear all)
    By mohan_984 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-25-2015, 10:39 AM
  3. Autofit Merged cells in a protected worksheet
    By Kymmy5555 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2014, 07:09 PM
  4. Clear contents of all unlocked cells (many are merged cells)
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 06-08-2009, 09:21 AM
  5. how do i link merged cells to a merged cell in another worksheet.
    By ibbm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-27-2006, 06:45 PM
  6. Clear Contents won't work on merged cells
    By ArthurJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-20-2006, 01:25 PM
  7. Replies: 1
    Last Post: 06-22-2005, 06:19 PM

Tags for this Thread

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