General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel - Cust. View ,Passwd Protect&Macro
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