LinkBack URL
About LinkBacks
Is there a way to make range of cells not clickable in Excel.
thanks
Is there a way to make range of cells not clickable in Excel.
thanks
Protect them
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
My file is Macro enabled, when i right click for protection, the option is not there.
Then the macro is designed to not allow you to do that. Go see the person who wrote the VBA
Maybe i did not ask the question with clarity.
I have a worksheet with all sort of values.
Is there a way to protect cell, that you cant click on them (I'm not asking about not editable)
I think if a cell is protected you still can click on it but not edit.
Thanks
Protect the worksheet and uncheck "Select Locked Cells" in the list of options. Cells are locked by default. If you want to grant access to cells and allow editing, select those cells, right click and choose Format Cells, Protection and deselect Locked.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks