Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
is it possible to merge cells in a protected worksheet?
Eric |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It sure doesn't look like it's possible to me.
Can you provide a macro that unprotects, merges, and reprotects? EG wrote: is it possible to merge cells in a protected worksheet? Eric -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
There was this guy in India who rolled across the continent on his back.
Using merged cells is like that - you can but for Gods sake WHY?! activesheet.protect Password:="", UserInterfaceOnly:=True 'code to merge In case you change your mind ;) Code to unmerge - [B2:D4].UnMerge Regards Robert McCurdy "EG" wrote in message ... is it possible to merge cells in a protected worksheet? Eric |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks, Robert. I have a spread sheet that i have some fairly complex
functions in one part of it, which i want to protect from being changed. in the other part of the sheet i want people to be able to manipulate and merge cells as they need to. Do i need to select the cells i want people to be able to change and then type: : ="", UserInterfaceOnly:=True ?? Thanks for your help! Eric "Robert McCurdy" wrote: There was this guy in India who rolled across the continent on his back. Using merged cells is like that - you can but for Gods sake WHY?! activesheet.protect Password:="", UserInterfaceOnly:=True 'code to merge In case you change your mind ;) Code to unmerge - [B2:D4].UnMerge Regards Robert McCurdy "EG" wrote in message ... is it possible to merge cells in a protected worksheet? Eric |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this with the sheet unprotected.
Select all the cells (ctrl + A), Ctrl + 1 pick the protection tab and uncheck the Locked check box OK. Now select the cells you want to protect, and repeat the above but this time tick the Locked check box. Go to Tools Macro Record New Macro..., Name it say ProtectMySheet, the defaults should be ok to store in This Workbook. OK. Now protect the sheet as you would normally. Stop recording. To get to see the code type the macro name into the Name box - far left of the formula bar, then press enter. Something like below is what you should see. Sub ProtectMySheet() ' ' ProtectMySheet Macro ' Macro recorded 15/10/2006 by EG ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True End Sub Now just edit the above to look like this: Sub ProtectMySheet() ' the commented bits here can be safely removed ' ProtectMySheet Macro ' Macro recorded 15/10/2006 by EG ActiveSheet.Protect Password:="Yourpassword", UserInterfaceOnly:=True _ DrawingObjects:=True, Contents:=True, Scenarios:=True, End Sub Another piece of code to unprotect the sheet is: Activesheet.unprotect "Yourpassword" Which you can have in another macro. You can assign these macros to objects, buttons or Events - check out the Help files on this. To answer - rather belatedly - your original question: Not unless you wish to provide the sheets password to all users. The above works only when the changes are made using VBA. So in your case you'd need to provide a different GUI with code (Userforms, etc). There are other options, all involve using VBA in some way. Regards Robert McCurdy "EG" wrote in message ... Thanks, Robert. I have a spread sheet that i have some fairly complex functions in one part of it, which i want to protect from being changed. in the other part of the sheet i want people to be able to manipulate and merge cells as they need to. Do i need to select the cells i want people to be able to change and then type: : ="", UserInterfaceOnly:=True ?? Thanks for your help! Eric "Robert McCurdy" wrote: There was this guy in India who rolled across the continent on his back. Using merged cells is like that - you can but for Gods sake WHY?! activesheet.protect Password:="", UserInterfaceOnly:=True 'code to merge In case you change your mind ;) Code to unmerge - [B2:D4].UnMerge Regards Robert McCurdy "EG" wrote in message ... is it possible to merge cells in a protected worksheet? Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Protected work sheet | Excel Discussion (Misc queries) | |||
Finding and compiling list of cells containing data... | Excel Worksheet Functions | |||
Auto "copy and paste" individual cells from various sheets into one sheet ?? | Excel Discussion (Misc queries) | |||
Still can select locked cells in protected sheet | New Users to Excel | |||
Allow unprotected cells to spell check after sheet is protected | Excel Worksheet Functions |