I am currently developing a worksheet where a number of cells have to be password protected. I have also desigend some Custom Views for viewing printing etc. adn I used >Group< to speed up the process within Custom View. The whole oepration for various Group are linked to a Macro which is operated via a button on the worksheet.
The Problem arises when I password protect the worksheet that Grouping and Custom View does not work.
To overcoem this I included two more Macros
a)Unprotect Worksheet,
b) protect worksheet
and incorporated this into the main macro which is operated via a button on the page. The function does solve the problem for the Grouping, and Custom views to function, (due to Protect and Unprotect Macros). At this point the Worksheet cells are protected.
However, I have noted that when I activate the Macro for a particular view, the Spreadsheet is duly protected, but if the user should go to >Tools>Protection>unprotect sheet
Excel automatically unprotects the worksheet without the need to input the password. This is not what I intended.
My QUESTION:
1. How can I write a Custom View that will work with Password Protection
2. How can I use Group with password protection
3. How can i write the macro to pull all of the above elements together without the problem I mention above occuring.
4) Can I password protect Macros so that they can not be changed
The best workable suggestions will get the total 1250 points. If there is a split then the award points will be shared equally