How to disable Merg cell in a sheet in excel?

If you have  a list record and have many user use it for data entry.
You don't want user to merg cell in that Sheet.

This is the solution :
1.Save your excel as Macro enable file type (*.xlsm).
2.Go to Developer tap  and click VB code.
3.Find the sheet you want to disable merg cell.
4.Then copy the Code below to that Sheet (vb code)

 Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Count > 1 Then Target.Cells(1).Select
End Sub

 5.Save and Test.


Other method is

1.Please go to review tab in excel  and Share workbook .
So your excel will  gray out of Merge excel icon in the work sheet.


Comments

Post a Comment

Popular posts from this blog

រូបគំនូរប្រវត្តិសាស្ត្រ ជាច្រើននៅលើជញ្ជាំងព្រះវិហារ វត្តកំពង់ធំត្រូវបានគេបង្ហាញ ក្រោយពេលវាយកំទេចចោលរាបស្មើដី

Image
រូបគំនូរប្រវត្តិសាស្ត្រជាច្រើនត្រូវបានលោក ព្រាប ចាន់ម៉ារ៉ា បង្ហាញនៅលើ Facebook របស់លោកដោយអារម្មណ៍សោកស្តាយយ៉ាងខ្លាំង ពេលទទួលដំណឹងថា រូបគំនូរ និង ព្រះវិហារដ៏ចំណាស់ ក្នុងវត្តកំពង់ធំ ត្រូវបានគេវាយកំទេចរាបស្មើដល់ដី បាត់ទៅហើយ។ បើតាមប្រភពព័ត៌មានបានអោយដឹងថា វត្តកំពង់ធំ ត្រូវបានសាងសង់ឡើងនៅឆ្នាំ 1633 ចំណែកឯព្រះវិហារ ត្រូវបានសាងសង់នៅក្នុងឆ្នាំ 1948 ខណៈពេលដែលគំនូរនៅលើជញ្ជាំងព្រះវិហារ ត្រូវបានគេគូរនៅក្នុងឆ្នាំ 1960 ពេលនេះត្រូវបានវាយកំទេចចោល ទោះបីធ្លាប់បានដាក់ជាបេតិកភណ្ឌជាតិ កាលពីឆ្នាំ 2007 យ៉ាងណាក្តី។ លោក ព្រាប ចាន់ម៉ារ៉ា បានរៀបរាប់នៅលើ Facebook លោកថា៖ “គំនូរជាប្រវត្តិសាស្ត្រនៅវត្តកំពង់ធំ គូរឆ្នាំ១៩៦០ មានរូបអ្នកដឹកនាំ​ល្បីៗ​លើលោកសម័យនោះ ដែលមានទំនាក់ទំនងជាមួយខ្មែរ ដូចជា ចិន, រុស្សី, អាមេរិក, ឥណ្ឌា, ឥណ្ឌូនេស៊ី, ភូមា… និងព្រះឆាយាលក្ខណ៍​ព្រះបរមរតនកោដ្ឋ។ល។ ដែលអ្នកស្រាវជ្រាវខ្មែរនិងបរទេស​ចាប់អារម្មណ៍​សិក្សា ត្រូវគេវាយកម្ទេចឲ្យវិនាសអន្តរាយ (ក្នុងព្រះវស្សា​និងក្នុងរដូវបុណ្យភ្ជុំបិណ្ឌឆ្នាំ២០១៧នេះ)”
Read more

How to use Vsphere?

Image
Using vSphere vSphere is a software solution for deploying and managing virtual machines across a datacenter. With vSphere, datacenters can instantly provision servers, globally manage resources, and eliminate scheduled downtime for hardware maintenance. Creating a datacenter Create a datacenter as a container for hosts, virtual machines, resource pools, and clusters. Datacenters are always created under the root folder in the Hosts and Clusters inventory of a single vCenter Server, in a folder under the root folder, or under a vCenter object in a Linked Mode inventory. To create a datacenter, select the vCenter Server system where you want to add the datacenter and select  Actions > New Datacenter . Creating a datacenter allows you to add hosts to it. Adding a host A host is a computer that uses virtualization software to run virtual machines. To add a host to the datacenter, you must have a computer running ESX or ESXi software. When you add a host, it will be managed by the v...
Read more

How to solved PDS SFC has stop working and unexpect error 908 on Accumark Gerber V9?

Image
I had meet an issue with Accumark Gerber V9.When i install it and patch it OK .But when i Open it Pattern Design it alert PDS SFC has stop working .. I try to solve by searching many forum but it nothing found. After i had checking Event viewer on window it said we error some thing with file Accumark Gerber V9.  After that i had reinstall it again but it still alert the same time. One way i found that i had install it work for other PC with cori5 x64  window 10 . after i copy  all file Accumark Gerver v9 from window 10 x64 to replace with window 7 that had error " PDS SFC has stop working " .I found that it solved the problem on window 7 x32..  It my lucky. But we still have other problem by error unexpected error 908 happened with Accumark Gerber 9 after we open it a while. I try to solved this problem again  by checking event viewer on window it said window shadow copy has stop working or disable .  So my solution is below: 1.Open service in window serve...
Read more