+ Reply to Thread
Results 1 to 2 of 2

How to "Protect" a worksheet but allow "Merging" of cells?

  1. #1
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Eastlake Ohio
    MS-Off Ver
    2018
    Posts
    1,106

    How to "Protect" a worksheet but allow "Merging" of cells?

    Is it possible to Protect a worksheet but allow "Merging" of cells?
    In my work book there are three sheets, one sheet I need to be able to merge or unmerge cells in two columns (F and G). The columns will either appear as one or two depending on the data being entered (Example: Numeric data either as a single entity, .500, or as a range .500 and .505).
    I have not found anything allowing to merge and or unmerge while sheet is protected!?
    Last edited by Rick_Stanich; 08-30-2007 at 01:02 PM.
    Regards

    Rick
    Win10, Office 365

  2. #2
    Forum Contributor Rick_Stanich's Avatar
    Join Date
    11-21-2005
    Location
    Eastlake Ohio
    MS-Off Ver
    2018
    Posts
    1,106
    I resolved this via VBA (Menu Item).
    I am reposting in the VBA forum for more questions.

    http://www.excelforum.com/showthread...82#post1823082

    Please Login or Register  to view this content.
    Last edited by Rick_Stanich; 09-04-2007 at 11:24 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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