Excel 2010 code that clears content of a cell on open
Closed
jamhome
Posts
1
Registration date
Saturday August 30, 2014
Status
Member
Last seen
August 31, 2014
-
Aug 31, 2014 at 09:10 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 9, 2014 at 11:34 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Sep 9, 2014 at 11:34 AM
Related:
- Excel 2010 code that clears content of a cell on open
- Gta v downloadable content - Download - Action and adventure
- Office 2010 free download - Download - Office suites
- Save as pdf office 2010 - Download - Other
- Cs 1.6 code - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Sep 9, 2014 at 11:34 AM
Sep 9, 2014 at 11:34 AM
Hi Jamhome,
Try the following code:
To implement, hit Alt+F11, locate "ThisWorkbook" on the left side of the newly opened window. Double click on it and paste the code in the big white field.
Best regards,
Trowa
Try the following code:
Private Sub Workbook_Open() Dim ws As Worksheet For Each ws In Worksheets Do ws.Select Cells.Find(What:="x", lookat:=xlWhole).ClearContents Loop Until Cells.Find(What:="x", lookat:=xlWhole) Is Nothing Next ws End Sub
To implement, hit Alt+F11, locate "ThisWorkbook" on the left side of the newly opened window. Double click on it and paste the code in the big white field.
Best regards,
Trowa