Hello,
I have the following macro code in my "Overview" excel sheet. I recorded the macro and it works perfectly.
The problem is that i have grouped some fields and after the sheet is protected, the grouping doesnt work anymore.
It says remove the protection and try again. I have used no password to protect the file.
Please Login or Register to view this content.
Thanks in advance,
Ranju
Last edited by ranjuv; 08-27-2012 at 08:47 AM.
What error?Now i want to protect the sheet and when i do that, the macro gives an error.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Arlette,
Sorry.. it gives an error now only with the grouping part. Rest is fine. I will edit the question.
Ranju
Do you do the grouping manually or via code? I do not see any code for grouping the rows in post 1.
I did it manually. After grouping, when i protect the sheet, the grouping doesnt work. I found some codes in the internet as a solution but i dont know where to include those... like if i should include them in between the current code or include them as a different object.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks