Run Time error 1004

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Run Time error 1004

FAQ

Thread Tools

Display Modes

06-13-2024, 04:42 AM

p45cal

Windows 10 Run Time error 1004

Office 2021

Expert

Join Date: Apr 2014

Posts: 956

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Me.Protect UserInterfaceOnly:=True, AllowFormattingCells:=True
Cells.FormatConditions.Delete
Target.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
Target.FormatConditions(1).Interior.ColorIndex = 40
End Sub

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Suddenly having trouble using .Refresh BackgroundQuery. Error 1004, General ODBC Error	PLSBRYDOBOY	Excel Programming	0	08-30-2019 12:17 PM
Error 1004 on EnvelopeVisable	mamies	Excel Programming	4	03-01-2017 05:14 PM
Run Time Error '1004'	galkej	Excel	0	02-03-2014 06:39 AM
Run-time error '1004': Document not saved. The document may be open...	doctor_who12	Excel Programming	1	01-22-2014 04:47 PM
Run time error 1004	yonasan	Excel Programming	3	06-12-2012 11:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:54 PM.