cellist
05-09-2014, 03:47 PM
I'd like to use VBA to invoke a Custom View ("CV"), so that the user doesn't need to first unprotect the worksheet and then remember to protect it again after the CV has been invoked. The user would initiate the VBA code by clicking a command button on the worksheet. The code would work something like this:
Collect the names of the CVs already defined for the worksheet.
Display a drop-down list of the names; user chooses the desired CV.
Collect the current protection settings (what's allowed when the worksheet is protected).
Unprotect the worksheet.
Invoke the desired CV using the choice from step.
Protect the worksheet using the protection settings saved in step 3
Thanks in advance for your consideration,
Phil
Collect the names of the CVs already defined for the worksheet.
Display a drop-down list of the names; user chooses the desired CV.
Collect the current protection settings (what's allowed when the worksheet is protected).
Unprotect the worksheet.
Invoke the desired CV using the choice from step.
Protect the worksheet using the protection settings saved in step 3
Thanks in advance for your consideration,
Phil