Merging cells in a Protected Sheet

  • Thread starter Protect Sheet but be able to merge cells
  • Start date
P

Protect Sheet but be able to merge cells

Does anyone know how to Merge cells once you have protected a sheet? There is
the option to 'allow users to format cells', but for some reason it will not
let me merge cells!!!
 
D

Dave Peterson

There are some things that aren't available in protected worksheets.

Merging cells is in that group.

If you really, really want to (I wouldn't!), maybe you could provide a macro
that:
unprotects the sheet
merges the cells you want merged
reprotects the sheet
 
S

Shane Devenshire

Hi,

The basic macro would be

Sub MyMerge()
ActiveSheet.Unprotect
Selection.Merge
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

If you have a password then check the VBA Help for Unprotect or Protect.
 

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

Protect sheet but be able to merge cells 1
How can I merge unprotected cells in a protected worksheet? 1
Merging cells on a protected work sheet 1
allow merging cells in protected sheet 1
Protected cells can't be grouped 1
Merging & Centering Cells 2
Sorting a protected set of cells 3
need assistance with merging cells 5

Top