Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a problem with Group and Ungroup. In a protected
rows or columns, I can't do Group and Ungroup. Can anybody help me with some macros that can resolve this? Thanks a bunch in advance. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The macro code needs to include a line at the beginning to unprotect th
sheet and another at the end to protect again. If you do not have the password you cannot do this. Otherwise I suggest you record a macro of your actions and come back i you need any further help - copy/paste the code in the message -- Message posted from http://www.ExcelForum.com |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, Brian.
Thanks for the reply. Can you give me example how to do it?. I mean .. I'm new to VBA Macros.. What do you mean by include a line?. I tried it, by putting "_______ or "----" can't help it. Thanks, -----Original Message----- The macro code needs to include a line at the beginning to unprotect the sheet and another at the end to protect again. If you do not have the password you cannot do this. Otherwise I suggest you record a macro of your actions and come back if you need any further help - copy/paste the code in the message. --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
group/ungroup protected sheets? | Excel Worksheet Functions | |||
How can I allow group ungroup while sheet is protected? | Excel Discussion (Misc queries) | |||
Group/Ungroup with sheet protected | Excel Discussion (Misc queries) | |||
Group and ungroup protected sheets | Excel Discussion (Misc queries) | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |