Hi hope all is well.
I have a dilemma with a vba project I built. I work in finance and have built a logon system with vba and works perfectly provided there is data there for the person.
I can’t post the code here because of the business I work in. Essentially providing there is data in the applications sheet it in turn customizes a set of graphs and also selects filters on two different pivot tables as well.
Essentially my code works for what I want but I need to address the last item for all in one solution. Do I use something like a countif first before code executes to check if the name is there and if it isn’t it doesn’t try open the sheets. In total I have three sheets I would need to do this on.
I have a dilemma with a vba project I built. I work in finance and have built a logon system with vba and works perfectly provided there is data there for the person.
I can’t post the code here because of the business I work in. Essentially providing there is data in the applications sheet it in turn customizes a set of graphs and also selects filters on two different pivot tables as well.
Essentially my code works for what I want but I need to address the last item for all in one solution. Do I use something like a countif first before code executes to check if the name is there and if it isn’t it doesn’t try open the sheets. In total I have three sheets I would need to do this on.