LinkBack URL
About LinkBacks
Hello all
just wondering how i can integrate the user to have the ability to hide/unhide rows&columns when the sheet is protected.
my code is below...much appreciated!
thxs!
Please Login or Register to view this content.
Hello all
just wondering how i can integrate the user to have the ability to hide/unhide rows&columns when the sheet is protected.
my code is below...much appreciated!
thxs!Please Login or Register to view this content.
The parameters you want to add to you protection scheme are:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by JBeaucaire; 07-22-2011 at 11:44 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
thx u kind sir!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
This allows the user to delete rows, not unhide/hide. is there a code for that?
The code in post #2 allows hiding and unhiding rows, too.
Thank you for the response, but I should have been more specfic---I only want to allow rows to be hidden/unhidden, not deleted or change row height or format. Is there a code to allow hide/unhide only?
I guess it will be good if you open a new thread for your question.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks