Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Private Sub Worksheet_SelectionChange(ByVal target As Range) ComboBox1.Top = ActiveCell.Top ComboBox1.Top = target.Top 'ComboBox1 value (if changed) will be stored in same row as target, column c Set oldTarget = Cells(target.Row, 3) ComboBox1.Height = ActiveCell.RowHeight - 6 ComboBox1.Width = 148 ' get out of column Headers If target.Rows.Count = Cells.Rows.Count Then Exit Sub If Not Intersect(target, [A1:AU1]) Is Nothing Then MsgBox "Not Allowed To Edit!", vbCritical, "Template Protection Error" Range("A2").Select End If End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|I would like to delete a cell in excel from which I think it has no use||2||33|
|Excel graph in access report||1||34|
|Embed XL WS and Objects into a PPTX||8||35|
|Format Control on two Buttons||6||25|
Join the community of 500,000 technology professionals and ask your questions.