Hi All,
I have the below code in my vba project but every time when i changed some data in my sheet columns will not get hide automatically but when i go to VBA property window and press F5 changes will be done in my sheet. can you please help me how to make this work automatically without going and pressing F5 in manually everytime.
Note - I have saved this file as Macro enabled worksheet and its enabled under File>option>trustCentre
Please Login or Register to view this content.
Last edited by anwitha; 07-10-2021 at 02:09 AM.
I can tell you why it's not running automatically, but first you need to stick to the forum rules and wrap the code in your original post in code tags.
BSB
sorry....this is done now.
For your code to run automatically it needs a 'trigger'. The way you currently have it set up, that trigger is pressing F5.
What you want to do is use a worksheet change event in the worksheet module. That way code can be triggered when a specified range is altered.
If you need more help than that, attach a sample workbook and explain which range(s) are to trigger the code and we can help more from there.
BSB
I am not able to attach the sample due to restriction in my laptop.
I have a calendar dates from 1 to 31st which is there in the cell from D4 to AH4...there are some months where we have only 30 days or 28 day in case of february..in such cases this should not show the columns which is beyond the actual end date in a month.....
but here in my sheet, even if the last working day is 30 its still showing the next column but when i pressed F5 then it will be hidden.
In the code column A1 refers to last day of the month.
Last edited by anwitha; 07-10-2021 at 02:43 AM.
What restriction in your laptop could possibly be preventing you from uploading a workbook? We are not asking to see real, sensitive data - just a realistic mock-up with a few rows of desensitised data.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
This is my company provided laptop where in i cannot upload any kind of the documents
That's a pain.
From your code I can see that cell A1 holds the information on how many days in the month. Is this something you select manually or is it derived by a formula looking elsewhere? If so, where?
Without a sample workbook there could be lots and lots of questions to get you the result you need. Can you not mock something up from another computer?
BSB
Below is the formula avaible in cell A1
=EDATE(DATE(C2,MONTH(1&B2),1),1)-1
In C2 cell i will update the year manually
In B2, cell is dropdown list where in i will select the months like January, February and based on this Cell A1 gives me the last date of the month.
Last edited by anwitha; 07-10-2021 at 03:00 AM.
It's difficult to know it will work without a sample workbook but we can try.
Right click on the sheet tab for the "Schedule" sheet and select "View Code".
Paste the code below in that module then see if it works when you change cells B2 or C2.
BSBPlease Login or Register to view this content.
This is working now....Thank you so much for your help
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
No problem. Happy to helpOriginally Posted by anwitha
This is working now....Thank you so much for your help
Thanks for the feedback.
Take care.
BSB
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks