The macro you need is sheet specific and runs whenever you change the sheet,
The macro checks to see if the cell that was changed was in column D.
If so the macro then reads the cell and modifies your spreadsheet.
If you had included a sample I'd know how to help you further.
How did you create a drop down list in the whole of column D.
why not on the top row and freeze the window?
Last edited by mehmetcik; 10-18-2013 at 03:47 PM.
I have created something to get you started.
change col d and columns get hidden
change column d again and columns get un hidden.
right click on the sheet name and select view code to see the macro.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks