Attached is the excel worksheet. I would like the order list sheet to hide/unhide each row in rows 5-500 in real time based on the value in K5:K500. If the value is positive it should be unhidden. If it is 0, it should be hidden. I have been able to do this with a calculating button but it is very slow. If the sheet could update in real time it would be best. I have tried to edit the order list code with no luck. Please can you help me with the code necessary if possible. Thank you in advance.
Last edited by Drewf2000; 02-16-2013 at 06:08 PM.
How is data entered into the sheet? Do you copy paste the data in it? Do you want the hide / unhide to be performed for the entire column (till K500) or only for the current row being updated?
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks