Hi,
Is it possible to hide (grey out) the conditional formatting button or disable it to prevent user to see the rules created?
Thanks.
Hi,
Is it possible to hide (grey out) the conditional formatting button or disable it to prevent user to see the rules created?
Thanks.
Maybe through VBA, but perhaps try and protect those cells and make them unavailable?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The cells with Conditional Formatting Rules required users to key in data.
I tried but it doesn't allow input data.
Or is there a command to disable the styles (including CF) to prevent user to click and view it? Thanks.
Last edited by cyliyu; 01-12-2019 at 12:40 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks