A
AccessHelp
Hello,
I have 4 differenct custom views in my Excel file. Since the worksheets in
my file are password-protected, I have a command button on one of the sheets
to call the form of various custom view selections.
So when I click on a command button on one of the custom view selections, it
switches to that custom view. I have no problem with calling the form nor
the code to run the custom view.
The problem that I am having is when I click on the button to run any of the
custom view selections, it takes a minute to change to the custom view that I
desired, instead of simultaneous change. I think that's because the file is
linked to other files to bring in the information.
How can I write a code to change the view simultaneously after the click?
Thanks.
I have 4 differenct custom views in my Excel file. Since the worksheets in
my file are password-protected, I have a command button on one of the sheets
to call the form of various custom view selections.
So when I click on a command button on one of the custom view selections, it
switches to that custom view. I have no problem with calling the form nor
the code to run the custom view.
The problem that I am having is when I click on the button to run any of the
custom view selections, it takes a minute to change to the custom view that I
desired, instead of simultaneous change. I think that's because the file is
linked to other files to bring in the information.
How can I write a code to change the view simultaneously after the click?
Thanks.