![]() |
Can't Group or Ungroup in Protected Cells
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. |
Can't Group or Ungroup in Protected Cells
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 |
Can't Group or Ungroup in Protected Cells
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/ . |
All times are GMT +1. The time now is 10:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com