George1972
New Member
- Joined
- Sep 9, 2014
- Messages
- 2
I would like to use VBA to hide/show a worksheet based on a portion of the filepath name.
For example:
If the filepath was D:\Data\My Documents\Projects\excelfile.xlsm
I want the worksheet to be visible if the beginning part of the path is D:\Data\My Documents, but then hide if the user saves the file to another location and the path changes
I am sure this can be done was hoping someone could help me out.
For example:
If the filepath was D:\Data\My Documents\Projects\excelfile.xlsm
I want the worksheet to be visible if the beginning part of the path is D:\Data\My Documents, but then hide if the user saves the file to another location and the path changes
I am sure this can be done was hoping someone could help me out.