Macro updating after selecting another sheet and back to Macro enabled sheet?

Hi Guys i am new to using Macros i have searched below mentioned codes from Google. Macro Code work perfectly but they dont update the sheet. Macro updating after selecting another sheet and back to main sheet. I have Bar/Column Charts on main sheet which update as per Macro Hid/Unhide rows. I want to share this file with my boss but how can i told him that First Select from Drop list and than select another sheet to update the charts. I want to update macro staying on same sheet. Please help.

Please Login or Register  to view this content.

where to add this after the above mentioned code or after any particular line

is there any other way where we don't need to press F9. it will auto generate. bcz bosses don't like to work hard

oh thank you dear thank you soooooo much finally solved

if you were near to me i would definitely kiss you thank you so much. for solving this