Hide/Unhide Excel File/s.

[omairhe]

Hey all,

I have a stock management .xlsm files for each month of the year 2019

These are named as follows in the folder named = Stock Share

01. January, 2019
02. February, 2019
03. March, 2019
04. April, 2019
05. May, 2019
06. June, 2019
07. July, 2019
08. August, 2019
09. September, 2019
10. October, 2019
11. November, 2019
12. December, 2019

On executing the code a text box should be introduced for the end-user to select any one month from these 12 months based on the first 2 digits
.
So that if the end-user inputs 01 for 01. January, 2019 this will unhide 01. January, 2019.xlsm and hide feb to dec.
But if the user inputs 06 for 06. June, 2019 this should Unhide all months from January to June and hide all months from July to December. and so on.

This would need ntfs file properties privileges?

Is it possible ?
Thank you and will appreciate.

 

[omairhe]

The vba that does this will have to reside inside each month's module sheet..